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?

[Zero Tolerance]

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

[jzewatsky]

Your suggestions worked....as usual.

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

[Zero Tolerance]

Glad to hear it

Enjoy,

- Zero Tolerance

[JD210]

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:

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

[JD210]

anyone?

[Marco van Herwaarden]

			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

[JD210]

That did it, thanks, much appreciated.