vb.org Archive - Wow, I must have been sleeping! Ver. 2.3?

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

- vB Chat (https://vborg.vbsupport.ru/forumdisplay.php?f=107)

- - Wow, I must have been sleeping! Ver. 2.3? (https://vborg.vbsupport.ru/showthread.php?t=77420)

Wow, I must have been sleeping! Ver. 2.3?

I'm running verson 1.1.0 on my board and would like to upgrade to 2.3. Is there any way someone can help me find the scripts to upgrade from 1.1.0 to 1.1.1 so I can begin the rest of the install process, It is not included in the zip it only goes back to 1.1.1-2.1. I thought maybe it would work to go 1.1.0-1.1.1 but it did not.

Thanks for the great hack and for all your time!!!!

P.S. Why is it that Zero has not been given Master Coder status? He has written some of the best hacks here and is great with support. How can fans/users of his hacks convince the powers that be to make that happen?

You'll have to drop the old DB modifications then do some little work, run these queries:
Before running, change "vb3_" to your table prefix :)
[sql]drop table vb3_vbchat_datastore[/sql]
[sql]drop table vb3_vbchat_store[/sql]
[sql]alter table vb3_user
drop vbchat_pref_font_face,
drop vbchat_pref_font_color,
drop vbchat_pref_status,
drop vbchat_pref_auto_on,
drop vbchat_pref_auto_msg,
drop vbchat_pref_in_room;[/sql]

Next step, install v2.3 fresh, including the file edits, if the edit is already done, re-do it :)

That should work, if you have any problems let me know.

As for the Master Coder title, its based on # of hacks released and # of people who have installed it, a bit crappeh really, seen as how you could release tons of little hacks and get the title, or release a couple of great hacks and have the title "Coder", but hey, nothings perfect.

- Zero Tolerance

Your suggestions worked....as usual.

Now I have vBchat & vBradio running on my forum. Mine and users favorites by far!!

Glad to hear it :)

Enjoy,

- Zero Tolerance

I deleted the queries and did a fresh install of the mod. Admin center works great, but when I try to go to my index page I get this:

Code:

Database error in vBulletin 3.0.3:



Invalid SQL: 

                SELECT

                        user.username, (user.options & 512) AS invisible, user.usergroupid,

                        session.userid, session.inforum, session.lastactivity, session.location session.location,

                        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

                FROM vb3session AS session

                LEFT JOIN vb3user AS user ON(user.userid = session.userid)

                WHERE session.lastactivity > 1118714670

                ORDER BY username ASC

        

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 '.location,

                        IF(displaygroupid=0, user.usergroupid, displaygro



mysql error number: 1064



Date: Monday 13th of June 2005 09:19:30 PM

Script: http://gothicgaming.com/forum/index.php?

Referer: http://gothicgaming.com/forum/index.php?

Username: John

IP Address: xx.xx.xx.xx

I can get into the portal page and into the catagories and forums no problem, but when I try to go to the index.php I get the above.

Help!!!

Code:

                        session.userid, session.inforum, session.lastactivity, session.location session.location,

I don't know this hack, but you have session.location twize there. Try removing it once

That did it, thanks, much appreciated.

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 (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02236 seconds Memory Usage 1,721KB 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 (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)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: