Nukemods Forum  
» Log in
User Name:

Password:

Not a member yet?
Register Now!
» Online Users: 93
6 members and 87 guests
besnj8stforesz6, int4qqgensivedr, kriste4ablesrdq, sexwiylry6inger, submjmersibletw, verdw2sicherung
Most users ever online was 611, 03-21-2008 at 11:10 PM.
» .::.
tattoo fonts
http://www.checkoutmyink.com/category/tattoo-fonts-tattoo

Go Back   Nukemods Forum > PHP-Nuke 7.x > Nuke 7.x - General

Reply
 
LinkBack Thread Tools Display Modes
Couldn't insert row in categories table...
Old
  (#1 (permalink))
Junior Member
 
Status: Offline
Posts: 3
Join Date: Feb 2006
Couldn't insert row in categories table... - 02-14-2006, 11:04 AM

Hi,

I get the following error when I try to insert and new category into my forum via the admin panel:

Quote:
Couldn't insert row in categories table

DEBUG MODE

SQL Error : 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 2

INSERT INTO nuke_bbcategories (cat_title, cat_order, cat_icon) VALUES ('Events', 20, )

Line : 510
File : admin_forums.php
Any ideas what could be causing this?

Thanks
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#2 (permalink))
Super Moderator
 
Duke's Avatar
 
Status: Offline
Posts: 1,016
Join Date: Dec 2005
Location: Under your bed
02-14-2006, 12:48 PM

It sounds like you may have an older version of mysql installed.

Try replacing the -- at the beginning of each entry with ## and see if it helps.

If not, can you post the entire code here?
  Send a message via AIM to Duke  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need News Categories block MaexM Nuke 7.x - Blocks 0 09-19-2006 11:11 AM
Using the PHPNuke user table for SQL insert script. protegechris Nuke 7.x - General 0 01-06-2006 08:18 AM
Sub Sub Categories not showing in Add Link LunaFaye Nuke 7.x - Modules 1 10-17-2005 07:10 PM
Article Categories in Phpnuke like FATCAT Significo Nuke 7.x - Modules 0 03-13-2005 09:46 PM
Could not insert data into users table SureFire Purged Topics 5 08-03-2003 02:08 AM




vBulletin Skin developed by: vBStyles.com


LinkBacks Enabled by vBSEO 3.3.0

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31