vb.org Archive - Db probs

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Db probs (https://vborg.vbsupport.ru/showthread.php?t=52965)

Jacko

05-14-2003 09:35 PM

Db probs

i get the following error when changing forum permissions such as HTML in posts.

Quote:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: UPDATE forum
SET
styleid='1', title='Site News', description='All the sites news posts are viewable in here.',
active='1', displayorder='2', parentid='1', parentlist='13,1,-1',
allowposting='1', cancontainthreads='1', daysprune='30',
newpostemail='', newthreademail='',
moderatenew='0', allowhtml='1', allowbbcode='1',
allowimages='1', allowsmilies='1', allowicons='1',
styleoverride='0', allowratings='1', countposts='1',
moderateattach='0', allowdollaroffers =
WHERE forumid='13'
mysql error: 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 'WHERE forumid='13'' at line 11

mysql error number: 1064

Date: Wednesday 14th of May 2003 02:16:59 PM
Script: http://www.realmods.net/forum/forum/admin/forum.php
Referer: http://www.realmods.net/forum/admin...edit&forumid=13

anyone know how to fix this at all??

Black Vivi

05-14-2003 10:03 PM

upload you're admin/forum.php file here, ill take a look, one of you're queries are missing summit

Boofo

05-14-2003 10:06 PM

It looks like you are missing the value for "allowdollaroffers" in the query.

Jacko

05-15-2003 05:43 AM

that ould be filburts dollar hack i guess.

lemme go over the instructions again for the file forum.php see if that fixes it.

Xenon

05-15-2003 12:33 PM

Code:

moderateattach='0', allowdollaroffers =

there should be a value after the last = ;)

@Black Vivi:
Nobody is allowed to attach full vb files!

filburt1

05-15-2003 12:45 PM

It's definitely my mod; there's the possibility that you'll get funky stuff when adding a forum (a bug I've fixed in present and future hacks) but editing a forum should work fine. Check the instructions again.

Jacko

05-15-2003 06:10 PM

right i did it again and i am not sure whats going wrong.

but it is when i do the following step:

Quote:

11. In admin/forum.php, find:

active='$isactive', displayorder='$displayorder', parentid='$parentid', parentlist=$parentlist,
allowposting='$allowposting', cancontainthreads='$cancontainthreads', daysprune='$daysprune',
newpostemail='".addslashes($newpostemail)."', newthreademail='".addslashes($newthreademail)."',
moderatenew='$moderatenew', allowhtml='$aallowhtmlcode', allowbbcode='$aallowbbcode',
allowimages='$aallowimgcode', allowsmilies='$aallowsmilies', allowicons='$aallowicons',
styleoverride='$styleoverride', allowratings='$allowratings', countposts='$countposts',
moderateattach='$moderateattach'

Replace with:

active='$isactive', displayorder='$displayorder', parentid='$parentid', parentlist=$parentlist,
allowposting='$allowposting', cancontainthreads='$cancontainthreads', daysprune='$daysprune',
newpostemail='".addslashes($newpostemail)."', newthreademail='".addslashes($newthreademail)."',
moderatenew='$moderatenew', allowhtml='$aallowhtmlcode', allowbbcode='$aallowbbcode',
allowimages='$aallowimgcode', allowsmilies='$aallowsmilies', allowicons='$aallowicons',
styleoverride='$styleoverride', allowratings='$allowratings', countposts='$countposts',
moderateattach='$moderateattach', allowdollaroffers = $allowdollaroffers

any ideas??

Jacko

05-15-2003 06:12 PM

i also get the following erro when trying to add a new group:

Quote:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO usergroup (candeleteusercomments, usergroupid,title,usertitle,starlevel,starimg,canc ontrolpanel,canmodifyprofile,canviewmembers,canvie w,cansearch,canemail,canpostnew,canmove,canopenclo se,candeletethread,canreplyown,canreplyothers,canv iewothers,caneditpost,candeletepost,canusepm,canpo stpoll,canvote,canpostattachment,ismoderator,canpu blicevent,canpublicedit,canthreadrate,cantrackpm,c andenypmreceipts,maxbuddypm,maxforwardpm,canwhoson line,canwhosonlineip)
VALUES (NULL,'Reviewers','','','',0,1,1,1,1,0,1,0,0,0,1,1 ,1,1,1,1,0,1,1,0,0,0,0,0,0,0,0,1,0,1)
mysql error: Column 'candeleteusercomments' cannot be null

mysql error number: 1048

Date: Thursday 15th of May 2003 03:09:00 PM
Script: http://www.realmods.net/forum/forum/admin/usergroup.php
Referer: http://www.realmods.net/forum/admin/...hp?action=add&

is this related??

filburt1

05-15-2003 06:17 PM

Somewhat. As I've said, some of my hacks that add a usergroup are broken in that respect but one of them (I think User Comments) has the fix which I haven't had time to implement.

Jacko

05-15-2003 07:16 PM

so this isnt fixable??

filburt1

05-15-2003 07:17 PM

The fix for yours has been made by another user. Like I said, please look in that thread. :)

Boofo

05-15-2003 11:02 PM

Jackjo, just change this:

PHP Code:


		
			
allowdollaroffers = $allowdollaroffers

to this in that query

PHP Code:


		
			
allowdollaroffers='$allowdollaroffers'

Jacko

05-16-2003 06:28 AM

cheers for that. i fixed it.

but i still get this error when adding a new group:

Quote:

Database error in vBulletin Control Panel 2.2.9:

Invalid SQL: INSERT INTO usergroup (candeleteusercomments, usergroupid,title,usertitle,starlevel,starimg,canc ontrolpanel,canmodifyprofile,canviewmembers,canvie w,cansearch,canemail,canpostnew,canmove,canopenclo se,candeletethread,canreplyown,canreplyothers,canv iewothers,caneditpost,candeletepost,canusepm,canpo stpoll,canvote,canpostattachment,ismoderator,canpu blicevent,canpublicedit,canthreadrate,cantrackpm,c andenypmreceipts,maxbuddypm,maxforwardpm,canwhoson line,canwhosonlineip)
VALUES (NULL,'Reviewers','','','',0,1,1,1,1,0,1,0,0,0,1,1 ,1,1,0,1,0,1,1,0,0,0,0,0,0,0,0,1,0,1)
mysql error: Column 'candeleteusercomments' cannot be null

mysql error number: 1048

Date: Friday 16th of May 2003 03:30:14 AM
Script: http://www.realmods.net/forum/forum/admin/usergroup.php
Referer: http://www.realmods.net/forum/admin/...hp?action=add&

any help??

Boofo

05-16-2003 07:19 AM

Try changing the NULL to $candeleteusercomments and see if that fixes it.

Jacko

05-17-2003 04:51 PM

sweet that worked. cheers mate.

Boofo

05-17-2003 04:53 PM

No problem. ;) That must be the fix filburt was talking about.

All times are GMT. The time now is 01:16 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01178 seconds Memory Usage 1,755KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (2)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (16)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: