I’ve made a site on my Mac using MAMP and, after going through the process outlined here:
http://www.modxcms.com/moving-sites-to-new-servers.html
I’ve moved it to my production server. Problem is I cannot log in. Came across a previous thread (
http://modxcms.com/forums/index.php/topic,1002.0.html) and tried editing the database table as described. No joy. If it helps, here’s the entire error message I see when trying to login with Firefox or Safari:
-----
The page at
http://www.dbennett.com says
<b>Warning</b>: mysql_num_rows(): supplied argument is not a valid MySQL result resource in
<b>/home/dbenne2/public_html/myclasses/manager/includes/settings.inc.php</b> on line <b>10</b>
<b>Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in
<b>/home/dbenne2/public_html/myclasses/manager/includes/settings.inc.php</b> on line <b>11</b>
<b>Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in
<b>/home/dbenne2/public_html/myclasses/manager/processors/login.processor.php</b> on line <b>72</b>
Incorrect username or password entered!
-----
Any ideas? Thanks!
David
EDIT: in case this makes a difference: I found I needed to change the SQL compatibility to MYSQL40 when exporting the database from my local MAMP install in order for it to import without errors to the production server.
