| Message Text |
I might be doing this wrong I followed my webhost's directions and I'm getting an error.
-I did a fresh install of wsnlinks 4.014 in debug mode, everything installed okay, to be sure I didn't miss anything I also ran servertest.php and there were no errors reported
-I then added 1 category and 1 link to my directory
-Now before doing a large amount of work on the site I wanted to make sure I knew how to do a proper backup and restore of the database
-So I tried using the backup/restore feature in the wsnlinks admin panel and it didn't work, the wsnlinks manual referred to possible problems because of mysql safemode, so I logged into my webhost to use PHPmyAdmin
-Once logged into PHPmyAdmin, I selected my database, clicked the export tab, clicked select all [structure and data], save as file, then clicked 'go', I now have a database.sql file on my local hard drive
-I opened up database.sql in notepad, then did a search for my added link to make sure the data had been exported, all looked okay (I didn't save or anything, but just closed the file)
-Next, I went back to my website, logged in and deleted the link, but left the category, I wanted to use the restore feature to restore the link
-After which, I went back to PHPmyAdmin, clicked on my database, went to SQL, run SQL query, selected the database.sql file and clicked 'go'
-The link wasn't restored and I received the following message:
SQL-query :
--
--
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * --
--
--
CREATE TABLE `wsnlinks_attachments` (
`id` int( 11 ) NOT NULL auto_increment,
`type` varchar( 255 ) NOT NULL ,
`objectid` int( 11 ) default '0',
`filename` varchar( 255 ) NOT NULL ,
`filetitle` varchar( 255 ) NOT NULL ,
`filesize` int( 11 ) default '0',
`width` int( 11 ) default '0',
`height` int( 11 ) default '0',
`memberid` int( 11 ) default '0',
`time` int( 11 ) default '0',
`deleted` tinyint( 1 ) default '0',
`field` varchar( 255 ) NOT NULL ,
`downloads` int( 11 ) default '0',
`validated` tinyint( 1 ) default '0',
`ownerip` varchar( 20 ) NOT NULL ,
UNIQUE KEY `id` ( `id` )
)ENGINE = MYISAM DEFAULTCHARSET = latin1
MySQL said:
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 '---------------------------------------------------------
--
--
I'm not sure if I'm doing something wrong.
_____
Derek |
