Nukemods Forum  
» Log in
User Name:

Password:

Not a member yet?
Register Now!
» Online Users: 96
6 members and 90 guests
besxjtphmo3aq7e, fed3feralgrants, forin9extraddpm, haingrcolky3rao, pro7mfessional6, XRumerTest
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 > General > Open topics

Reply
 
LinkBack Thread Tools Display Modes
SQL_Layer errors
Old
  (#1 (permalink))
Junior Member
 
Status: Offline
Posts: 94
Join Date: Jan 2003
Location: Brooklyn
SQL_Layer errors - 05-08-2003, 02:13 PM

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/bayridge/public_html/includes/sql_layer.php on line 301
Unknown column 'width' in 'field list'

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/bayridge/public_html/includes/sql_layer.php on line 301
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

Thats the error im getting... Im made changes to the Nuke_Banners table to be able to add flash banners. The Normal banner works fine, but the block banner gives me that error.

These are the 3 fields I added....

flash tinyint(1) DEFAULT '1' NOT NULL,
flash_width int(3) DEFAULT '0' NOT NULL,
flash_height int(3) DEFAULT '0' NOT NULL,
  Send a message via AIM to Br00klynzzfinest  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#2 (permalink))
Moderator
 
Status: Offline
Posts: 957
Join Date: Nov 2002
Location: Belgium
05-08-2003, 02:19 PM

It is looking for a column named width but it seems you added flash_width.
try to add
Code:
flash_width int(3) DEFAULT '0' NOT NULL


Yannick R. aka Mighty_Y
http://support.code-area51.com
http://www.code-area51.com

Search before asking makes my life easier!
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#3 (permalink))
Moderator
 
Status: Offline
Posts: 338
Join Date: Jan 2003
05-08-2003, 02:19 PM

Among the fields you added i see one called flash_width yet your code is lloking for one called width, i'd say the code needs some editing.
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#4 (permalink))
Moderator
 
Status: Offline
Posts: 957
Join Date: Nov 2002
Location: Belgium
05-08-2003, 02:22 PM

We seem to have postd at the same time


Yannick R. aka Mighty_Y
http://support.code-area51.com
http://www.code-area51.com

Search before asking makes my life easier!
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#5 (permalink))
Moderator
 
Status: Offline
Posts: 338
Join Date: Jan 2003
05-08-2003, 02:33 PM

:P
   
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old
  (#6 (permalink))
Junior Member
 
Status: Offline
Posts: 94
Join Date: Jan 2003
Location: Brooklyn
05-08-2003, 03:48 PM

lol... thanks guys. I got it all fixed up =)
  Send a message via AIM to Br00klynzzfinest  
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
Page Errors mortician Nuke 7.x - General 0 02-16-2006 07:32 PM
Forum SQL errors Bluefin221 Nuke 7.x - General 0 01-31-2005 03:30 AM
sql_layer.php on line 286 ERROR Virus Imp Nuke 6.5 to 6.9 - Blocks 0 04-04-2003 07:07 PM
includes/sql_layer.php on line 301 IACOJ Open topics 7 01-08-2003 11:39 AM
Installation problems with sql_layer.php ReidStylez Purged Topics 2 12-12-2002 03:40 PM




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