Db probs

[filburt1]

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

[Boofo]

Jackjo, just change this:

PHP Code:

allowdollaroffers = $allowdollaroffers 


to this in that query

PHP Code:

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/...hp?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.