Db probs

[Jacko]

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

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]

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

[Boofo]

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

[Jacko]

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]

moderateattach='0', allowdollaroffers =

there should be a value after the last = ;)

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

[filburt1]

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]

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

but it is when i do the following step:

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]

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

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/usergroup.php?action=add&


is this related??

[filburt1]

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]

so this isnt fixable??

[filburt1]

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

[Boofo]

Jackjo, just change this:

allowdollaroffers = $allowdollaroffers

to this in that query

allowdollaroffers='$allowdollaroffers'

[Jacko]

cheers for that. i fixed it.

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

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/usergroup.php?action=add&

any help??

[Boofo]

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

[Jacko]

sweet that worked. cheers mate.

[Boofo]

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