vb.org Archive - Collapsable forums on forum home

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

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Collapsable forums on forum home (https://vborg.vbsupport.ru/showthread.php?t=33961)

it works so fine now

thanx

Code:

Database error in vBulletin Control Panel 2.2.6:



Invalid SQL: INSERT INTO forum

                      (forumid,styleid,title,description,active,displayorder,parentid,

                       parentlist,allowposting,cancontainthreads,daysprune,newpostemail,newthreademail,

                       moderatenew,allowhtml,allowbbcode,allowimages,allowsmilies,allowicons,

                       styleoverride,allowratings,countposts,moderateattach)

                   VALUES

                      (NULL,'1','test','','1','1','-1',

                       '','1','1','30','','',

                       '0','1','1','1','1','1',

                       '0','1','1','0','')

mysql error: Column count doesn't match value count at row 1



mysql error number: 1136

thats the error i get, This hack didnt work at all for me, i get that error when i try to add another forum.

This all started when i went thru with the altering templates, the index and /admin/forum.php files to what the readme said then i went to run the installer, it wouldnt do anything just kinda look, id lick install and it would just sit there, id click uninstall and it would just sti there so i added the install stuff manually thu phpmyadmin.

I uninstalled everything and I still cant add forums, any thoughts would be nice thanks

Quote:

Originally posted by Timmmmmy

Code:

Database error in vBulletin Control Panel 2.2.6: Invalid SQL: INSERT INTO forum (forumid,styleid,title,description,active,displayorder,parentid, parentlist,allowposting,cancontainthreads,daysprune,newpostemail,newthreademail, moderatenew,allowhtml,allowbbcode,allowimages,allowsmilies,allowicons, styleoverride,allowratings,countposts,moderateattach) VALUES (NULL,'1','test','','1','1','-1', '','1','1','30','','', '0','1','1','1','1','1', '0','1','1','0','') mysql error: Column count doesn't match value count at row 1 mysql error number: 1136

thats the error i get, This hack didnt work at all for me, i get that error when i try to add another forum.

This all started when i went thru with the altering templates, the index and /admin/forum.php files to what the readme said then i went to run the installer, it wouldnt do anything just kinda look, id lick install and it would just sit there, id click uninstall and it would just sti there so i added the install stuff manually thu phpmyadmin.

I uninstalled everything and I still cant add forums, any thoughts would be nice thanks

Assuming you are after uninstallation, then the colum count in that query doesn't match you need to remove the last entry, which will read " ,'$collapsed' " in fact the whole before and after for that line is in the readme. Now coming on to the installer which/what version of php are you using and could you clarrify "just sit there"? does it not progress past the first step?

I have vb 2.2.6 and when i searched for if ($forum['cancontainthreads']==1) {
$tempext = '_post';
} else {
$tempext = '_nopost';
} It wasn't found in index.php

sorry, i click on it, it says at the bottom going to step 2, but doesnt do anything. I had to manually enter the sql data, and ive removed them too. The same thing happens when i go to uninstall it.
Thanks

Thanks, i thought i had taken everything out, I removed ",'$collapsed' " from the /admin/forum.php and it worked.

Quote:

Originally posted by Graphics
I have vb 2.2.6 and when i searched for if ($forum['cancontainthreads']==1) {
$tempext = '_post';
} else {
$tempext = '_nopost';
} It wasn't found in index.php

Assuming your index.php is unmodified lines 305 to 309 will contain those lines.

Quote:

Originally posted by Timmmmmy
sorry, i click on it, it says at the bottom going to step 2, but doesnt do anything. I had to manually enter the sql data, and ive removed them too. The same thing happens when i go to uninstall it.
Thanks

Installer and the hack will fail to work correctly on php older than 4.0.x, PHP 4.1.x or 4.2.x is required for succesful installation.

template_option.txt
What are these setting for?

I have it working, except it won't remember settings?

I have all but one forum catagory to be collapse as standard, tried in IE5.5 NS6.01 Mozilla 0.9.9 Galeon 1.2.0

many thanks

Quote:

Originally posted by carpman
template_option.txt
What are these setting for?

Optional additional code, generally if you don't know what its for you don't need it.

Quote:

I have it working, except it won't remember settings?

Random guess upload update_index.php to your forums directory.

Quote:

Originally posted by dabean

Optional additional code, generally if you don't know what its for you don't need it.

Random guess upload update_index.php to your forums directory.

thanks for reply.

If someone told me what they are for i could make my own mind up?

I have uploaded updateindex.php, this is the one that came in the zip file!!!

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01326 seconds Memory Usage 1,750KB 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 (2)bbcode_code_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (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
Messages: