it happened to me and i just repeated what you have just done and it somehow worked, i didnt do it cos i knew what i was doing, i was just trying different things on phpmyadmin and it worked

its ok i had to remove the edit from ucash in the memberinfo template

Try this one.

Is there a query I can run to remove anything refering to or containing ushop?

Fatal error: Call to undefined function: replace_template_variables() in /web/www.mysite.com/html/installer/class_installer.php on line 708

guys here are the tables I've dropped so far.. maybe Jay since he's done this already can add maybe I missed a few and the superbowl is starting :)

STEP 1:
-------
DROP TABLE `vb_ushop_action` ,
`vb_ushop_asvs` ,
`vb_ushop_bank` ,
`vb_ushop_category` ,
`vb_ushop_history` ,
`vb_ushop_item` ,
`vb_ushop_item_cat` ;

STEP 2:
-------
ALTER TABLE `vb_forum`
DROP `ucash_perthread` ,
DROP `ucash_perreply` ,
DROP `ucash_perview` ,
DROP `ucash_perdownload` ;

STEP 3:
-------
ALTER TABLE `vb_user`
DROP `ushop_history` ,
DROP `ushop_glow` ,
DROP `ushop_usernamecolor` ,
DROP `ushop_boldusername` ,
DROP `ushop_italicsusername` ,
DROP `ushop_bankdata` ,
DROP `ushop_bankqueue` ,
DROP `ushop_bankwarning` ,
DROP `ushop_profilemidi` ,
DROP `ushop_bypassflood` ,
DROP `ucash` ;

STEP 4:
-------
ALTER TABLE `vb_usergroup`
DROP `ushop_discount`,
DROP `ucash_paycheck`,
DROP `ushop_options`;

Hmm. Try

Hi, im doing a fresh install got this problem:

Database error in vBulletin 3.5.3:

Invalid SQL:
CREATE TABLE ushop_action (
`actionid` int(5) NOT NULL auto_increment,
`categoryid` smallint(5) NOT NULL default '1',
`shortname` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`displayorder` int(10) NOT NULL default '0',
`cost` varchar(20) NOT NULL default '',
`tax` varchar(20) NOT NULL default '',
`sold` bigint(10) NOT NULL default '0',
`defaultquantity` bigint(10) NOT NULL default '0',
`quantity` bigint(10) NOT NULL default '0',
`allowedgroups` varchar(255) NOT NULL default '',
`deniedgroups` varchar(255) NOT NULL default '',
`expiration` int(15) NOT NULL default '0',
`noexpiremarkup` decimal(20,2) NOT NULL default '0.00',
`filelocation` varchar(255) NOT NULL default '',
`imagelocation` varchar(255) NOT NULL default '',
`disablecoupon` tinyint(1) NOT NULL default '0',
`showinstore` tinyint(1) NOT NULL default '0',
`active` tinyint(1) NOT NULL default '0',
`saf_name` varchar(50) NOT NULL default '',
`asvs` text NOT NULL,
`itemcatcache` text NOT NULL,
`itemcache` text NOT NULL,
PRIMARY KEY (`actionid`)
);

MySQL Error : Table 'ushop_action' already exists
Error Number : 1050
Date : Monday, February 6th 2006 @ 12:38:52 AM
Script : http://ourhabboforum.be/installer/index.php
Referrer : http://ourhabboforum.be/installer/index.php
IP Address : 82.34.122.216
Username : xRoyal15
Classname : vb_database

You sure this is your first time running this install?

yer, i had ebux before if that might be why...

uh oh, round 1, FIGHT!

/me reserves for possible future install

I'm not sure, however, ebux should not add that table...

Try running the following query

I'm gonna kill myself .... dropped all tables, re-installed - COPIED new installed.php yet same error!

Importing Product, please wait

[:]

Fatal error: Call to undefined function: replace_template_variables() in /home/content/d/n/e/dnelite/html/installer/class_installer.php on line 708

Fatal error: Call to undefined function: replace_template() in /web/www.mysite.com/html/installer/class_installer.php on line 708

It doesn't seem to be finding the replace_template() function for some reason. What file would this be located in?

It's just
replace_template(some code here)

If you want to search for it just search for
replace_template(


I will try and post a fix shortly.

Cool, thanks.


The only instance of "replace_template(" that shows up is in the class_installer.php file, and there's only the one reference to it on line 708. The function itself doesn't seem to be defined anywhere.

ok on step 4 it says:

Database error in vBulletin 3.5.3:

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 : Monday, February 6th 2006 @ 12:50:20 AM
Script : http://ourhabboforum.be/installer/index.php
Referrer : http://ourhabboforum.be/installer/index.php
IP Address : 82.34.122.216
Username : xRoyal15
Classname : vb_database

got a query for that?

If I'm not mistaken, there's either a typo or an error with calling the function. It may not exist in one of the files used in installation or a typo in the name.

ucash conflicts with it

I will be back shortly (in a couple of minutes). If anyone finds a fix, feel free to post it.

Let me know if this works.

bloody hell its bug-a-licious

got the query yet for my problem?


Database error in vBulletin 3.5.3:

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 : Monday, February 6th 2006 @ 12:50:20 AM
Script : http://ourhabboforum.be/installer/index.php
Referrer : http://ourhabboforum.be/installer/index.php
IP Address : 82.34.122.216
Username : xRoyal15
Classname : vb_database

Seems like you already have ucash installed. Try upgrading instead of installing. Choose the upgrade option in installation.

I think ill stick with ebux

I think your posting here was extremely useful and disrespectful. But then again, that's just my opinion.

still same error here even w/new installer.php

Step 7) Importing Product

Importing Product, please wait

[:]

Fatal error: Call to undefined function: replace_template_variables() in /home/content/d/n/e/dnelite/html/installer/class_installer.php on line 708

I'll fix that shortly. For now, move on, and then import it manually. Let me know if it works then. After that, you should be good to go.

why don't you do that and get off this thread? Let the rest of us who want uShop work on this and stop hi-jacking and posting stupid comments..

Thank you. I am setting up another test forum to solve that bug now.

Otherwise, Jay has it installed successfully and i hope you will to shortly after doing what i said.

I'm getting a error when I change a users info in admincp it is:
Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE user SET
### Bitfield: user.options ###
options = IF(options & 8, options - 8, options),
options = IF(options & 1024, options - 1024, options),
options = IF(options & 16, options, options + 16),
options = IF(options & 256, options, options + 256),
options = IF(options & 512, options - 512, options),
options = IF(options & 32, options - 32, options),
options = IF(options & 2048, options, options + 2048),
options = IF(options & 4096, options - 4096, options),
options = IF(options & 1, options, options + 1),
options = IF(options & 2, options, options + 2),
options = IF(options & 4, options, options + 4),
options = IF(options & 64, options, options + 64),
options = IF(options & 128, options - 128, options),
options = IF(options & 32768, options - 32768, options),

WHERE userid = 1;

MySQL Error : Unknown column 'ucash' in 'field list'
Error Number : 1054
Date : Sunday, February 5th 2006 @ 07:17:47 PM

IP Address :
Username : Rdsx
Classname :

mines installed and its working nicely,i just cant be bothered to update the permissions yet, this ushop is a lot better than ebux and a lot better than previous ushop versions

I installed it manually and it works... problem is when I click on Donate or richest members it says "No actions found"

Update quantity.

huh? So you installed it untill the error in step 7 and then you did....what??

I installed manually the .xml through the Product Manager...

What happens to you on step 7?

Updating style information for each style

Default Style ... (Templates) (StyleVars) (CSS) (Replacement Variables) (Controls) Done.

Importing Admin Help, Please Wait...

[:]

Invalid File Specified

(Stops and no NEXT button)

Yup i'm checking that out now.

getting there guys and thanks to gio~logist for his patience .. great support.

installed manually and admin sections seem to now create errors when attempting to update anything :-