Home N-13 News Forums Help Search
RegisterForgot password?
How to add image to post necklacesdiscou
Known bugs - 4.0.3 necklacesdiscou

Latest N-13 News 4.0.3

What is N-13 News?
Where can I get help?
Known bugs

Forums Help & Support from localhost to remote server
wwwdoe
Posted on 14 Feb 2012, 23:06:06

Access: Member
Total Posts: 5
Joined: 2012-02-01

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

#3712
Last edited by wwwdoe at 2012-02-19 09:16:40 Reason: error message was'nt correctly formatted
DreadManCandy
Posted on 15 Feb 2012, 15:02:49

Access: Member
Total Posts: 17
Joined: 2012-01-17

Hi there,

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.

Good Luck

#3714
wwwdoe
Posted on 16 Feb 2012, 08:37:14

Access: Member
Total Posts: 5
Joined: 2012-02-01

'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?

#3715
Chris
Posted on 17 Feb 2012, 18:14:32

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

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.

#3729
wwwdoe
Posted on 19 Feb 2012, 09:16:40

Access: Member
Total Posts: 5
Joined: 2012-02-01

Solved. There was a stupid mistake: they gave me a wrong hostname. Thanks however.

#3740
Network-13.com © 2013