Bug Make proper installer

[E.T.]

Hi,

With import the xml from beta 13 the following message appears:

The product is not compatible with vBulletin versie 4.1.5

 

[Darkwaltz4]

Did you upgrade vb recently? What version of vb were/are you using with the previous beta?

 

[E.T.]

Nothing changed, vb4.1.5 tested with all previous beta versions.

 

[Darkwaltz4]

hm, ok, well delete this line out of the product xml

<dependency dependencytype="vbulletin" minversion="4.0.0" maxversion="4.1.5" />

should work for you then.

 

[E.T.]

Deleted, but still not working.

Now I got a database error.

Database error in vBulletin 4.1.5:

Invalid SQL:
ALTER TABLE `dbtech_vbarcade_data` ADD `history_winner` int(10) unsigned NOT NULL DEFAULT '0';

MySQL Error : Duplicate column name 'history_winner'
Error Number : 1060
Request Date : Wednesday, August 31st 2011 @ 06:02:01 AM
Error Date : Wednesday, August 31st 2011 @ 06:02:01 AM
Script : http://www.dbf4all.eu/forum/admincp/plugin.php?do=productimport
Referrer : http://www.dbf4all.eu/forum/admincp/plugin.php?do=productadd
IP Address : 83.161.254.66
Username : E.T.
Classname : vB_Database
MySQL Version : 5.1.41-community

I must go to work now, will try it later today

 

[Ozzy47]

Well that stinks, I am sure DW will get it sorted for you.

 

[Darkwaltz4]

did you clean install?

otherwise, if thats already apparently in place, then you just need to upload the updated files and youre upgraded

 

[Freekoid]

Database Error Clicking Featured Game

Latest upgrade to beta13, there is no games panel to browse.

Clicking featured game results in this error.

Database error in vBulletin 4.0.6:

Invalid SQL:

		SELECT d.*, g.*, r.rating AS myrating, f.userid AS myfavorite,
			l.userid AS luserid, lu.username AS lusername, lu.infractiongroupid AS ligid, lu.usergroupid AS lugid, lu.displaygroupid AS ldgid, l.global AS lglobal, l.score AS lscore,
			h.userid AS huserid, hu.username AS husername, hu.infractiongroupid AS higid, hu.usergroupid AS hugid, hu.displaygroupid AS hdgid, h.global AS hglobal, h.score AS hscore
		FROM dbtech_vbarcade_game AS g
		LEFT JOIN dbtech_vbarcade_favorite AS f ON (f.gameid = g.gameid AND f.userid = 1)
		INNER JOIN dbtech_vbarcade_data AS d ON (d.gameid = g.gameid)
		LEFT JOIN dbtech_vbarcade_session AS l ON (l.sessionid = d.local_winner)
		LEFT JOIN dbtech_vbarcade_session AS h ON (h.sessionid = d.history_winner)
		LEFT JOIN user AS lu ON (lu.userid = l.userid)
		LEFT JOIN user AS hu ON (hu.userid = h.userid)
		LEFT JOIN dbtech_vbarcade_rating AS r ON (r.gameid = g.gameid AND r.userid = 1) 
		WHERE g.gameid = 'lampofaladdinv32mrX' AND g.enabled = 1;

MySQL Error   : Unknown column 'd.history_winner' in 'on clause'
Error Number  : 1054
Request Date  : Wednesday, August 31st 2011 @ 12:39:54 AM
Error Date    : Wednesday, August 31st 2011 @ 12:40:03 AM
Script        : http://www.muppet-testee.info/test/arcade.php?game=lampofaladdinv32mrX
Referrer      : http://www.muppet-testee.info/test/arcade.php
IP Address    : 
Username      : TPB
Classname     : vB_Database
MySQL Version : 5.1.56

 

[Darkwaltz4]

the product import didnt add the column??

 

[Freekoid]

Let me up the xml once more.

 

[Freekoid]

Ok, were good ~ strange!

 

[Ozzy47]

lol something like that would only happen to you.

 

[Freekoid]

lol something like that would only happen to you.

Uhuh, I still cant score, will start new thread when I got all the relevant data.

 

[Darkwaltz4]

are you sure you didnt just forget to import the product? its troubling that the installcode didnt do its job (since that would be a vb bug)

 

[E.T.]

Hi,

Not a clean install, just upgraded and I saw the score management is in place.

So don't need to use the .xml ?

 

[Darkwaltz4]

Well not sure how your install magically added that column, since it is new in this beta, but whatever. ill have to make the proper installer at some point, so ill hang onto this issue.

 

[E.T.]

Well the column is added, but it's not working. Cannot delete or archive any scores.

 

[Darkwaltz4]

Delete and archive has nothing to do with that column though. What happens when you try to do it?

 

[E.T.]

Nothing at all.

Shall I remove the complete arcade and reinstall ?

 

[Darkwaltz4]

well, if you dont mind the trouble i guess?
have you tried to see if global scoring works for you btw? (just curious)