I'm trying to migrate n-13 from localhost to remote server. After changing parameters in db.php file, when I enter the news index page or admin page, appears the following error message:
Error: Statement: SELECT * FROM news30_options WHERE 1 Arguments:
Array ( )
It's there something else to be set up?
Thank you in advance
Did you export your sql database from localhost into the new one??? If you haven't, try that. Post back any arrors you're getting and I'll try and help.
I have done this several times successfully so I may be able to help.
'course, I did it, and everything went smoothly. The server is Apache 2.2.9 Php 5.2.6. the db.php file is configured as follow:
define('HOSTNAME', 'myhostname'); define('USER', 'myuser'); define('PASS', 'mypassword'); define('DATABASE', 'mydatabase'); define('PORT', ''); define('SOCKET', ''); define('EXTENSION', 'mysql');
seems to be a connection issue, or what?
Assuming you've copied the database correctly to the new server including all the tables + data, then it's most likely a username/password issue or possible a database name problem, do the databases have the exact same name? some hosts prefix database names with your username.
Solved. There was a stupid mistake: they gave me a wrong hostname. Thanks however.