Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'ucash_rounddecimal',
'ucash',
'2',
'2',
'free',
'',
70,
0,
1,
'ucash'
),
(
'ucash_enablesystem',
'ucash',
'1',
'1',
'free',
'yesno',
30,
0,
1,
'ucash'
),
(
'ucash_perthread',
'ucash',
'2',
'20',
'free',
'',
40,
0,
1,
'ucash'
),
(
'ucash_perview',
'ucash',
'.10',
'1',
'free',
'',
60,
0,
1,
'ucash'
),
(
'ucash_pointsforbreputation',
'ucash',
'0',
'1',
'free',
'',
63,
0,
1,
'ucash'
),
(
'ucash_pointsforgreputation',
'ucash',
'5',
'1',
'free',
'',
62,
0,
1,
'ucash'
),
(
'ucash_pointsperreferral',
'ucash',
'25',
'100',
'free',
'',
61,
0,
1,
'ucash'
),
(
'ucash_pointsfield',
'ucash',
'ucash',
'ucash',
'free',
'',
20,
0,
1,
'ucash'
),
(
'ucash_pointtable',
'ucash',
'user',
'user',
'free',
'',
10,
0,
1,
'ucash'
),
(
'ucash_perreply',
'ucash',
'1',
'15',
'free',
'',
50,
0,
1,
'ucash'
),
(
'ucash_pointspercharacter',
'ucash',
'0.01',
'0.01',
'free',
'',
51,
0,
1,
'ucash'
),
(
'ucash_governmentbank',
'ucash',
'0',
'0',
'free',
'yesno',
31,
0,
1,
'ucash'
),
(
'ucash_governmentbankst',
'ucash',
'0',
'0',
'free',
'yesno',
32,
0,
1,
'ucash'
),
(
'ucash_pointsforregistering',
'ucash',
'10',
'0',
'free',
'',
38,
0,
1,
'ucash'
),
(
'ucash_paycheck',
'ucash',
'604800',
'604800',
'free',
'',
80,
0,
1,
'ucash'
);

MySQL Error : Duplicate entry 'ucash_rounddecimal' for key 1

thats what i get when trying to upload the xml file

Got the same error :ermm:

Fine. I'll take it down until this stupid error is fixed.

just to let you know it installed fine on my forum

EDIT: No it comes up with this when I save usergroup permissions:

Database error in vBulletin 3.5.0 Release Candidate 1:
Invalid SQL:
UPDATE FORUMusergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<span style=\"color: blue;\">',
`closetag` = '</span>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`ucash_paycheck` = '0.00',
`forumpermissions` = '1048575',
`attachlimit` = '0',
`pmquota` = '1000',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '31',
`profilepicmaxwidth` = '200',
`profilepicmaxheight` = '200',
`profilepicmaxsize` = '200000',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '200000',
`profileviewpermissions` = '0',
`ecdownloadpermissions` = '2047'
WHERE usergroupid=6;
MySQL Error : Unknown column 'ucash_paycheck' in 'field list'
Error Number : 1054
Date : Saturday, July 30th 2005 @ 03:14:52 AM
Script : http://www.burnleyweb.com/community/admincp/usergroup.php
Referrer : http://www.burnleyweb.com/community/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : 212.***.***.***
Username : *********
Classname : vb_database

NOOOO! No no no! :(

I just upgraded to RC1. Dammit. I hope I grabbed this already.

*edit* Oh. It's still there. I wet myself in fear for nothing. :)

The SQL error reported by pepel13 happened to me too. However, if you use the HIS to uninstall the tables, then the errors go away and the product import is fine.

Any news on when uShop will be available?

Tonight, or Link's nose is going to be a little sore in the morning ;)

(Just kidding, UCash being my favorite hack of all time, I'd never do a thing like that :))

-RD

I forgot a query for the paycheck feature I added. I'll get this all fixed tommorow.

Is this file attached for download yet: uCash_1.1.1_Release_Candidate_1_for_vB3.5_RC1_[2005-07-29].zip I dont see it!?!

Edit: Oh, ok, your working on fixing a problem........kk

@Link14716
Do you plan releasing this as a Product, without File Edits?
(Hooks forumadmin_edit_form and useradmin_edit_column1 could be used for the File Edits currently necessary)
If not, would you mind if I attach such a Version here?

I'd like that :)

[high]* jesus likes pie punches link in the face and then says sorry but reminds him that it is endeed the 1st of August![/high]

That's what 1.1.1 does, but I haven't gotten the upgrading part right yet.

I'd like the v1.1.1 (the 1 with lots of 1s)

I like the simplicity/economics of the uCash system, so the next P3tz release will work with uCash. I guess I'll just use v1.1.0 and use the new acp hooks rather than file edits.

GoodGame

Oh and hooks are cool!

FYI:
I have just made the install and rest of the hack use the product and hack system. The product thing is really great. I have installed and uninstalled and then installed and uninstalled... and then installed... ucash in just a few clicks...

may I be the first to say... *PUNCH*

Nope. Look 3 posts above yours.

Alright, I think I got upgrading from uCash 1.1.0 (and 1.0.0 for that matter) fixed. Time for 1.1.1 RC2! :)

Is uShop released yet? I might be missing it somewhere. If it is, can you LMK where I can grab it? Thanks.

Not yet. Even when it is, it will be an Alpha release with no upgrade path from uShop 0.95. ;)

I just installed this, no trouble at all good job (can not wait for alpha of store seeing as this is all new install for myself)

Does anyone have any trouble installing 1.1.1 RC2?

Looks good Link. Lovin' the no file edits :D

-RD

Its all working for me, I installed fast and easy, set up options then forum options. Mass gave points with 100 credit, plus 5 points a post and it all worked as should.

great job man, thanks for sharing

If no one reports a bug by sometime tommorow, I'll make this a final.

I do know of one bug though. I don't think I have the global bank row inserted into the datastore, so that feature won't work. No worries right now, since that feature is all but useless at the moment.

seems to be working on mine, but no one can do anything with the points yet ;-)

Would it ever be possible to remove points from a user? Say if he's spamming the board, can you remove points as a warning to him?

I'm working on it, damnit. :p

If you edit a user in the Admin CP, you have the option of altering their point total (it's under the profile fields).

I don't know about that. I have some very frugal users and they're always tossing their cash into the bank!

hi.. when installed im getting this error after posting

Database error in vBulletin 3.5.0 Release Candidate 1:

Invalid SQL:
UPDATE user SET ucash=ucash+0 WHERE userid='2';

MySQL Error : Unknown column 'ucash' in 'field list'
Error Number : 1054
Date : Wednesday, August 3rd 2005 @ 02:32:53 AM
Script : http://www.secfanatics.com/vbulletin/newreply.php
Referrer : http://www.secfanatics.com/vbulletin...3980#post23980

What version of uCash are you using?

Works fine *clicks Install*

Side Question: is it possible to give users the the ability ot make "Points" any name they want like "Money", "Cash", etc.? let me know, thanks

Edit the phrases ucs_points and ucs_points_lower in your Phrase Manager. (Use the search function in your admincp to find them.)

I believe this is good enough to go final. Changes since RC2:

build_forum_permissions() added to the installation, inserted ucs_global_bank into the datastore (not fetched yet, but the forum bank is off by default and is pretty useless at the moment).

Daydreaming...
heh

It's the one that was availible lastnight which is probably the current one
it's 1.1.1 RC2 btw and im running VB 3.5 RC1

everything seemed to go well but when a post is made it gives that error

I have the same error that fpouk is having.. in my case for what I have been able to diagnose, the alter scripts weren't able to run.. the weird thing in my case I upgraded from .93c I believe, I still see the settings in the dropdown menu in general settings but I can't see the fields in the user table per se for it, so prolly the install scripts gets messed up in that part. any way to force a fresh installation?

If you are upgrading from uCash & uShop 0.93 or 0.95 and experience those errors, run these 2 queries:

[sql]ALTER TABLE user CHANGE `uttpoints` `ucash` DECIMAL(20, 2) DEFAULT '0' NOT NULL;

ALTER TABLE forum
CHANGE `uttpoints_perthread` `ucash_perthread` varchar(20) DEFAULT '1' NOT NULL,
CHANGE `uttpoints_perreply` `ucash_perreply` varchar(20) DEFAULT '1' NOT NULL,
CHANGE `uttpoints_perview` `ucash_perview` varchar(20) DEFAULT '1' NOT NULL;[/sql]

It appears that I made a mistake in the queries in the product file. I'll update the zip in a minute.

Sorry for the error. :)

EDIT: The zip file is now updated to fix the problem. Run those two queries if you have already installed 1.1.1.

ahh its good to go now thanks

just 1 ?
can users send points to each other? if so how?
reason i ask is because i run a sports site and my users want to use the points system for wagering on games

the only reason I still stay with vb3.0 is because I can't miss the Ushop.

It means I am waiting day by day for its release, where is it Link ?