• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

MySQL Syntax Error

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Using ...
JForum 2.1 (not 2.1.3)
MySQL 4.1.7

There was no problem using the installation wizard. And I can also access the first page of the forum after installation.
When I clicked to access the default "Test" topic, it showed me an 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 '?, ?' at line 1

Here is the stack trace. Any idea? thx for your help.


[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Looks like a problem with the LIMIT clause.. Are you using the mysql driver which comes with jforum (3.1.4) or you changed it? JForum will not work correctly with 3.1.6 or 3.1.7.

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Actually I don't know which version of driver I'm using.
I installed both software and config the param in JForum installation wizard.
So I suppose it will use the driver come with jforum.
How can I check the version and change to use a specific driver?
Thx for your prompt response.

Rafael Steil wrote:Looks like a problem with the LIMIT clause.. Are you using the mysql driver which comes with jforum (3.1.4) or you changed it? JForum will not work correctly with 3.1.6 or 3.1.7.

Rafael


[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I've tested that I'm using the MySQL driver come with JForum,
coz I removed it from WEB/lib and I got the driver missing exception.
So anybody tried with the same config (jforum 2.1 + mysql 4.1.7)
Or I should use JForum 2.1.3?
What is the recommended version of MySQL?
Thx.
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I fixed it using another version of MySQL driver.
(v3.0.10, v3.0.12 and v3.0.14 all works fine)
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hhmm.. I guess 4.0.x will also work. I did some fixes for mysql 4.1.x, but looks like some more are needed.. :roll:

Rafael
[originally posted on jforum.net by Rafael Steil]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I confirm it works with 3.0.14 but not with the provided 3.1.4
[originally posted on jforum.net by pala]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Is this really a live discussion board?
[originally posted on jforum.net by Anonymous]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ummm, if it is not and this is a dead discussion board, that would make us "zombies", so I guess the answer is: yes, it is alive!!

8)
[originally posted on jforum.net by GreenEyed]
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic