808smokey Posted June 3, 2004 Share Posted June 3, 2004 I need your help I get this error when I try to change the status from pending to shipped in my admin controls: 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 '' at line 1 select products_description as desc_info from products_description where products_id = [TEP STOP] I never changed anything so I don't know where to start. Any help would be appreciated. Thanks Link to comment Share on other sites More sharing options...
808smokey Posted June 3, 2004 Author Share Posted June 3, 2004 Here's my setting in PHPadmin for products_description: Field Type Attributes Null Default Extra Action products_id int(11) No auto_increment language_id int(11) No 1 products_name varchar(200) No products_description text Yes NULL products_url varchar(255) Yes NULL products_viewed int(5) Yes 0 products_head_title_tag varchar(80) Yes NULL products_head_desc_tag longtext Yes NULL products_head_keywords_tag longtext Yes NULL Check All / Uncheck All With selected: Are those correct Link to comment Share on other sites More sharing options...
808smokey Posted June 8, 2004 Author Share Posted June 8, 2004 PLease help figure this out... For days I've been trying to fix and I'm lost. It makes no sense at all Here's what i've found in mysql database. I have two databases aplus2_(1) and aplus_osc2(46) Now the first one is blank, ABSOLUTLY nothing in it. Should I delete that one and see if that fixes it? I'm afraid if I do it will erase everything?? To add to the confusion, I can't figure out how to delete it anyways :lol: :lol: <_< :angry: :( :blink: *EDIT* Alright I spoke too soon. I can delete from the hosts frontend cpanel. Should I delete it??? Thanks for any help and replies Link to comment Share on other sites More sharing options...
Guest Posted June 8, 2004 Share Posted June 8, 2004 Can you manually change the status using phpmyadmin? Link to comment Share on other sites More sharing options...
808smokey Posted June 8, 2004 Author Share Posted June 8, 2004 Can you manually change the status using phpmyadmin? Nope I can't do anything to it. When I click it in phpmyadmin it shows: "No tables found in database. " and none of the options across the top are usable. Other then structure and sql, those are blank. I'm thinking I should delete it. I "think" it's the 1st play around dbase I had when I was starting out. Gonna back it up 1st though Link to comment Share on other sites More sharing options...
808smokey Posted June 8, 2004 Author Share Posted June 8, 2004 http://aplus-computersonline.com/catalog/i...untitled111.bmp That's the error that shows up. I'm completly lost........ :( Link to comment Share on other sites More sharing options...
808smokey Posted June 8, 2004 Author Share Posted June 8, 2004 Oh I forgot to mention that I deleted the blank dbase and it had no effect. I also ran all the chack,repair,optimze options in PHPmyadmin and still nothing. Everything said "OK" Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.