Regardless of why I wasn't successful I went back to reinstall my backup.sql and I get this error in php myadmin
SQL query:
CREATE TABLE wsnlinks_email(
id int( 11 ) NOT NULL AUTO_INCREMENT , TO text NOT NULL , subject text NOT NULL , message text NOT NULL , headers text NOT NULL , timesent int( 11 ) NOT NULL default '0', ip text NOT NULL , replacement text NOT NULL , mime tinyint( 1 ) NOT NULL default '0', UNIQUE KEY id( id ) ) TYPE = MYISAM MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'to text NOT NULL, subject text NOT NULL, message text NOT
-------------------------------------- I had to reinstall via setup.php and ran the back up through admin but then I get these errors above the site and then admin crashes.
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/thrifty/public_html/dir/classes/database.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/thrifty/public_html/dir/classes/database.php on line 31
The last version I had installed took the backup.sql smoothly.
What's happening? I don't know enough mySQL to fix this.
Comments on Emergency...backup.sql problem
Forum Regular
Usergroup: Customer
Joined: Nov 26, 2003
Total Topics: 70
Total Comments: 211
My site is down until I fix this!
Version 3.3.9
Created backup.sql in admin for safety before making any changes. I was trying to add a ton of links using the guidelines provided on www.webmastersite.net/forum...9&highlight=import%20links.
Regardless of why I wasn't successful I went back to reinstall my backup.sql and I get this error in php myadmin
SQL query:
CREATE TABLE wsnlinks_email(
id int( 11 ) NOT NULL AUTO_INCREMENT ,
TO text NOT NULL ,
subject text NOT NULL ,
message text NOT NULL ,
headers text NOT NULL ,
timesent int( 11 ) NOT NULL default '0',
ip text NOT NULL ,
replacement text NOT NULL ,
mime tinyint( 1 ) NOT NULL default '0',
UNIQUE KEY id( id )
) TYPE = MYISAM
MySQL said:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'to text NOT NULL,
subject text NOT NULL,
message text NOT
--------------------------------------
I had to reinstall via setup.php and ran the back up through admin but then I get these errors above the site and then admin crashes.
Warning: mysql_list_fields(): Unable to save MySQL query result in /home/thrifty/public_html/dir/classes/database.php on line 30
Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/thrifty/public_html/dir/classes/database.php on line 31
The last version I had installed took the backup.sql smoothly.
What's happening? I don't know enough mySQL to fix this.
Forum Regular
Usergroup: Customer
Joined: Nov 26, 2003
Total Topics: 70
Total Comments: 211
I have fixed this by using the ingenuity of another poster...
see https://www.webmastersite.net/forums/thread/6333 if anyone else has the same problem
Mysql chokes on the email table.