Arrow Home arrow Forums
larger font smaller font default font Fixed screen resolution Auto adjust screen size

Advertise on this site

Joomlapolis Forums  


DB function failed with error number 1064
Date: 2007/11/08 02:16 By: bins Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 3
graphgraph
I am doing a clean install of my site and am trying to tie gj and fireboard together.

I am sure I have followed the instruction correct, but have got the following error when trying to update old groups:

DB function failed with error number 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 'n Roll', 0, 0, 0, 1, 66, 0, 0, 0, 0, 1, 0, 1, 0, now(), 0, 0, '')' at line 1 SQL=INSERT INTO jos_fb_categories (parent, name, cat_emoticon, locked, alert_admin, moderated, moderators, pub_access, pub_recurse, admin_access, admin_recurse, ordering, future2, published, checked_out, checked_out_time, review, hits, description) VALUES ('8', 'Rock 'n Roll', 0, 0, 0, 1, 66, 0, 0, 0, 0, 1, 0, 1, 0, now(), 0, 0, '')


I am using the latest version of everything and it worked a few days ago when I originally did it!
Click here to see the profile of this user The administrator has disabled public write access.

Re:DB function failed with error number 1064
Date: 2007/11/08 10:18 By: beat Status: Admin  
Karma: 231  
Admin

Posts: 3631
graphgraph
groupJive bug...
Beat - Developer on Community Builder core Team
- If you like CB and this forum, you will love Nick's CB 1.1 reference manual ! : Click here to Get it now
- Would like to help us move faster ? Get it, and/or help us spend more time coding by helping others in this forum, many thanks
Click here to see the profile of this user The administrator has disabled public write access.

Re:DB function failed with error number 1064
Date: 2007/11/08 10:27 By: bins Status: User  
Karma: 0  
Fresh Joomlapolitan

Posts: 3
graphgraph
aha!!!

any more info? I am interested why it has appeared now and nt on previous install.

Most importantly, how do I correct it?
Click here to see the profile of this user The administrator has disabled public write access.

Re:DB function failed with error number 1064
Date: 2008/07/19 13:32 By: Sulpher Status: User  
Karma: 2  
Fresh Joomlapolitan

Posts: 17
graphgraph
For those who need this Groupjive bug to be corrected, write a PM on me for paid help.
Click here to see the profile of this user The administrator has disabled public write access.

Documentation

Documentation Subscription Service
(updated for CB 1.2 RC2)

What?

Why?

Where?

Just click here for answers!

Click here for a yearly subscription: subscribe now

Download Latest Release

The latest stable Community Builder Release is version 1.1 for Joomla 1.0 and Mambo.
You need to be a registered member of Joomlapolis to download.

The latest release candidate of Community Builder is version 1.2 RC2, native for Joomla 1.0, 1.5 and Mambo.
It is available as "thank you" to all CB documentation subscribers at this time.

CB Login