vb.org Archive
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

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??


All times are GMT. The time now is 08:11 AM.
Page 1 of 2 1 2
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01193 seconds
  • Memory Usage 1,740KB
  • 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
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete