» Log in
User Name:

Password:

Not a member yet?
Register Now!
» Online Users: 59
0 members and 59 guests
No Members online
Most users ever online was 611, 03-21-2008 at 11:10 PM.
» .::.
Web Hosting - web hosting, dedicated servers and web design services
Online Degree - search for 1000+ online degrees, online colleges & online universities.
Tattoo - we are a group of tattoo enthusiasts
Gexa Energy - your absolute best choice in electric service
Texas electricity - save on electric rates
Football Betting - best nfl betting promotions at sportsbook.com.
Oral Chelation - initial cleansing of your veins & arteries
Portatiles - Ofertas en Ordenadores y Portatiles. Increibles Ofertas DELL.

Register Now! Contact Us

About this Page
This is a discussion on Couldn't insert row in categories table... within the Nuke 7.x - General forums, part of the PHP-Nuke 7.x category; Hi, I get the following error when I try to insert and new category into my forum via the admin ...


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

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 02-14-2006, 11:04 AM
Junior Member
 
Join Date: Feb 2006
Posts: 3
Couldn't insert row in categories table...
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
  #2 (permalink)  
Old 02-14-2006, 12:48 PM
Duke's Avatar
Super Moderator
 
Join Date: Dec 2005
Location: Under your bed
Posts: 1,002
Send a message via AIM to Duke
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?
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


All times are GMT -5. The time now is 08:07 PM.


Design by Vjacheslav Trushkin, color scheme by ColorizeIt!.

LinkBacks Enabled by vBSEO 3.1.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