uCash & uShop v2.0.0

As of June 4th 2006 the uCS project is officaly closed.

For more info please see this thread. https://vborg.vbsupport.ru/showthread.php?t=117590

[ffevo]

Originally Posted by gio~logist

Do the following to delete all instances of ushop and ucash (this will delete everything in ushop and ucash)

DELETE *
FROM `yoursite_test`.`datastore`
WHERE `title` LIKE '%ushop%'
OR `data` LIKE '%ushop%'
LIMIT 0 , 30

Then

DELETE *
FROM `yoursite_test`.`datastore`
WHERE `title` LIKE '%ucash%'
OR `data` LIKE '%ucash%'
LIMIT 0 , 30

Replace yoursite with whatever your databases have before the name.

wtf. I dont Understand what you mean.

ALSO Ive istalled this damn hack halfway through..and Now it doesnt want to to let me install it the rest of the way. It tells me that " I have the latest version" When Ive cleared and repaird all my tables.. wtf?

[ffevo]

LOL Okay Boys. I got it to Install. and It was my own fault it wasnt installing. Good work on getting those bugs out.

[VietLang]

How do you remove "uCash" and "uShop" in the Admin CP?
I had so much trouble getting it to work, I wanted to uninstall/delete everything then install it again.

Thanks

[Stone Cold 3:16]

I wanna restart the install. Whats this error mean:

Database error in vBulletin 3.5.4:

Invalid SQL:
ALTER TABLE forum
	ADD `ucash_perthread` varchar(20) NOT NULL default '',
	ADD `ucash_perreply` varchar(20) NOT NULL default '',
	ADD `ucash_perview` varchar(20) NOT NULL default '',
	ADD `ucash_perdownload` varchar(20) NOT NULL default '';

MySQL Error  : Duplicate column name 'ucash_perthread'
Error Number : 1060
Date         : Tuesday, February 28th 2006 @ 07:55:56 PM
Script       : http://www.prowrestlingstop.com/installer/index.php
Referrer     : http://www.prowrestlingstop.com/installer/index.php
IP Address   : 66.139.221.215
Username     : Stone Cold 3:16
Classname    : vb_database

[Smiry Kin's]

Think it means it already excists..

[Zacarias]

I give up on this... I can't get past step 9, and un-installing and re-installing does nothing.

The upgrade always gets an error...

[ambumann]

I had difficulties using the uninstaller as well, had to manually remove the tables and entries from the database in order to upgrade.

[ericgtr]

Nice mod here guys. I am having an issue though,

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT 
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_estore AS phrasegroup_estore,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid)) 

WHERE user.userid = 7262;

MySQL Error  : Unknown column 'language.phrasegroup_estore' in 'field list'
Error Number : 1054
Date         : Wednesday, March 1st 2006 @ 10:27:37 AM
Script       : http://www.guitars101.com/vb/estore.php?do=donate&userid=11703
Referrer     : 
IP Address   : xx.xx.xx.xx
Username     : 
Classname    : vb_database

And

Database error in vBulletin 3.5.1:

Invalid SQL:

SELECT languageid,
phrasegroup_estore AS phrasegroup_estore,
phrasegroup_global AS phrasegroup_global,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1;

MySQL Error  : Unknown column 'phrasegroup_estore' in 'field list'
Error Number : 1054
Date         : Wednesday, March 1st 2006 @ 08:54:32 AM
Script       : http://www.guitars101.com/vb/estore.php?do=donate&userid=11703
Referrer     : 
IP Address   : xx.xx.xx.xx
Username     : 
Classname    : vb_database

Missing field list?

[ericgtr]

I think I got it now, I needed to run the xml script. That is burried in there and it's not clear that you need to run it, it also overwrites the normal install.

It appears that the phrases are missing, when I go into any of the Change Username, Glow etc. they all come up to a page with missing phrases.

[Daniel Thomas]

I error when I try to go to Step 9, on the ushop.php page, it says: Oh, btw, I'm using the ushop-ucash 2.00 and ucash 1.1.1

PHP Code:

Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE ushop_action SET quantity=defaultquantity WHERE defaultquantity > quantity;

MySQL Error  : Table 'afigueir1.ushop_action' doesn't exist
Error Number : 1146
Date         : Thursday, March 2nd 2006 @ 01:37:20 AM
Script       : http://ringsidemayhem.com/forums/ushop.php
Referrer     : http://ringsidemayhem.com/forums/index.php
IP Address   : 24.XXX.XXX.XX
Username     : Daniel Thomas
Classname    : vb_database