1
supernix
MySQL Bug
  • 2004/2/7 7:56

  • supernix

  • Not too shy to talk

  • Posts: 151

  • Since: 2003/3/13


I turned on MySQL debugging and this is the error that I recieved:


SELECT id, name, directory, hidden, lastUpdate, submitter FROM xoops_icontent_pages WHERE hidden=0 AND submitter=298 ANDORDER BY lastUpdate DESC LIMIT 0, 5
Error number: 1064
Error message: 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 'ANDORDER BY lastUpdate DESC LIMIT 0, 5' at line 1


2
Dave_L
Re: MySQL Bug
  • 2004/2/7 8:24

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


The "AND" in "ANDORDER" is probably appended by mistake. I don't know which module uses the xoops_icontent_pages table, but that would be the place to look.

3
supernix
Re: MySQL Bug
  • 2004/2/7 8:37

  • supernix

  • Not too shy to talk

  • Posts: 151

  • Since: 2003/3/13


Thanks,

I bet that is something to do with the Icontent module.

Login

Who's Online

191 user(s) are online (128 user(s) are browsing Support Forums)


Members: 0


Guests: 191


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits