>>help!!!!<<

[lackattack]

My site when whack, and i have a database backup and it gives me errors galore. And there is alot more, it just is the start.

Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 293515
STR: '
SQL:

INSERT INTO class_admin (id, title, keywords, description, url, urls, email, notify, maximage, version, mainTemplate, mainIndexCols, mainCatCols, mainSubCols, mainTakeOffline, mainTakeOfflineReason, mainEmailValidation, smtp, smtpHost, smtpUsername, smtpPassword, smtpPort, mailHTML, htmlEditor, removeTime, showTotal, adminTemplate) VALUES (\'1\', \'Canada\\\'s Autos\', \'CLASSIFIED ADVERTISING, AUTO TRADER, CARS, VEHICLES, HEAVY EQUIPMENT, BOATS, MOTORCYLES, SNOWMOBILES, TRUCKS, TRACTORS, RV, ACURA, ALFA ROMEO,CHRYSLER, FORD, GENERAL MOTORS, PONTIAC, OLDSMOBILE, NISSAN, DATSUN, TOYOTA, LEXUS, INFINITY, MERCURY, FREIGHLINE\', \'Canada\\\'s best way to find new and used cars, trucks, bikes, snowmobiles, RVs. Millions of classified ads are placed weekly using our new website.\', \'http://www.canadasautos.ca/\', \'\', \'[email protected]\', \'N\', \'4\', \'v4.0.9\', \'dmtmedia_rounded\', \'3\', \'3\', \'2\', \'N\', \'We are updating our servers please check back soon\', \'Y\', \'N\', \'\', \'\', \'\', \'\', \'Y\', \'Y\', \'7\', \'Y\', \'default\');
#
# TABLE STRUCTURE FOR: class_badwords
#

DROP TABLE IF EXISTS class_badwords;

CREATE TABLE `class_badwords` (
`wordID` int(11) NOT NULL auto_increment,
`wordName` varchar(255) NOT NULL default '',
`wordReplacement` varchar(255) NOT NULL default '',
PRIMARY KEY (`wordID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

INSERT INTO class_badwords (wordID, wordName, wordReplacement) VALUES (\'1\', \'fuck\', \'****\');
INSERT INTO class_badwords (wordID, wordName, wordReplacement) VALUES (\'2\', \'shit\', \'****\');
INSERT INTO class_badwords (wordID, wordName, wordReplacement) VALUES (\'3\', \'fucker\', \'******\');
INSERT INTO class_badwords (wordID, wordName, wordReplacement) VALUES (\'4\', \'mother fucker\', \'****** ******\');
INSERT INTO class_badwords (wordID, wordName, wordReplacement) VALUES (\'5\', \'bullshit\', \'*******\');
INSERT INTO class_badwords (wordID, wordName, wordReplacement) VALUES (\'6\', \'pussy\', \'*****\');
INSERT INTO class_badwords (wordID, wordName, wordReplacement) VALUES (\'7\', \'site sucks\', \'**** *****\');
#
# TABLE STRUCTURE FOR: class_categories
#

DROP TABLE IF EXISTS class_categories;

CREATE TABLE `class_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`slug` varchar(255) NOT NULL,
`description` varchar(255) default NULL,
`image` varchar(255) default NULL,
`allowads` char(2) default NULL,
`display` char(1) NOT NULL default 'Y',
`cOrder` int(11) NOT NULL default '0',
`cKeywords` varchar(255) NOT NULL default '',
`cPromo` text NOT NULL,
`cLink` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `parent_id` (`parent_id`),
KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=327 DEFAULT CHARSET=utf8;

[Lhotch]

you need to back up a few steps and give us some background on whats going on.

What do you mean site went whack....exactly?

Next you say you have a database backup and then show a bunch of SQL errors but dont give us any details on if the backup was recent, from the same exact version of 68C or if these sql errors were caused from trying to restore the backup or how you are even doing the restore.

[lackattack]

Sorry,

Yeah so i tried updating my 68 classifieds v4.0.9 to v4.1.0 and the template i had went all weird.

I backuped all my files before and the database from the admin panel. I want to go back to v4.0.9

I then uploaded all the files and inserted through phpmyadmin into the database. And it gave me those errors.

Then i installed fresh, v4.0.9, and then inserted the SQL file from the admin panel in 68 classifieds and it gives me the same errors.

The backup was done an hour or two ago.

[lackattack]

Please anyone, i can give $20 to whoever can help fix it. But payment would have to be made on the 30th of this month. Im waiting upon PayPal to send money to my bank account so i can verify it.

[Eric Barnes]

Hi,

Please submit a ticket with as much detail as you can and we can see if we can help you out.

[goodpony]

I am also receiving errors on my site: "Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 231200480 bytes) in Unknown on line 0" to the degree that the site completely failed and I when I tried to visit the site it was a white page with the same sort of Fatal Error Message. I have submitted a suport ticket to both my host and to 68classifieds and have just contacted ioncube and am waiting on a reply. The error I am getting is inconsistent....one minute its there the next things seem to be working fine. I am at a loss as to what to do as I am new to working with any kind of databases/loaders etc.. If you visit the site and search on anything in the drop down menu the error pretty consistently pops up. Then again it might not....though in most instances it will.

Would really appreciate any help on how to resolve the problem. lisa
v.4 designer

DressagePony.net