vb.org Archive - Major Additions - ICash, Simple, stand alone point system.

Page 83 of 119

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Major Additions - ICash, Simple, stand alone point system. (https://vborg.vbsupport.ru/showthread.php?t=119086)

agsguar

07-15-2007 04:24 AM

Sorry, again me.

But how can i view the last 10 donations (to me)??

is this possible??

Thank you!!

jeremyalyea

07-15-2007 05:32 AM

I currently have vbookie installed and I am trying to integrate the icash system into it. Every time I try to import the icash xml file, I get the databse error listed below. I have read through the posts and have changed 'money' to 'vbookie_cash', but I'm still getting errors. I have spent a couple of hours on this and still nothing. Would anyone be willing to shed some light?

Quote:

Invalid SQL:
if not exists (select 'vbookie_cash' from user)
ALTER TABLE user ADD COLUMN 'vbookie_cash' decimal(15,2) DEFAULT '0' NOT NULL;

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 'if not exists (select 'vbookie_cash' from user)
ALTER TABLE user ADD' at line 1
Error Number : 1064

Caseyjr86

07-15-2007 02:48 PM

What do i need to do? I just tried importing and I get this error.. I've never had I cash before.. either..

Quote:

Database error in vBulletin 3.6.7:

Invalid SQL:
if not exists (select icash_prethread from forum)
ALTER TABLE forum ADD COLUMN icash_perthread DECIMAL(30, 5) NOT NULL DEFAULT '10';

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 'if not exists (select icash_prethread from forum)
ALTER TABLE forum ADD COL' at line 1
Error Number : 1064
Date : Sunday, July 15th 2007 @ 10:46:12 AM
Script : http://www.*****.com/admincp/plugin....=productimport
Referrer : http://www.****.com/admincp/plugin.php?do=productadd

And for giggles I reran it, and now get this error..

Quote:

Database error in vBulletin 3.6.7:

Invalid SQL:
ALTER TABLE user ADD COLUMN money decimal(15,2) DEFAULT '0' NOT NULL;

MySQL Error : Duplicate column name 'money'
Error Number : 1060
Date : Sunday, July 15th 2007 @ 10:50:10 AM
Script : http://www.***.com/admincp/plugin.php?do=productimport
Referrer : http://www.****.com/admincp/plugin.php?do=productadd

Blaine0002

07-15-2007 03:16 PM

OOPs! bad column checking on my part!
Redownload and reimport, should work fine now!

whitevans1

07-15-2007 08:56 PM

atabase error in vBulletin 3.6.7:

Invalid SQL:

UPDATE user
SET `money` = `money` + 0
WHERE userid = '1';

MySQL Error : Unknown column 'money' in 'field list'
Error Number : 1054
Date : Sunday, July 15th 2007 @ 05:57:26 PM
Script : http://www.run3h4x.net/forum/newrepl...treply&t=13847
Referrer : http://www.run3h4x.net/forum/showthread.php?t=13847
IP Address :
Username :
Classname : vb_database

Blaine0002

07-15-2007 09:09 PM

Now, you must have just overwritten the product

Uninstall ICASH and THEN import the XML and it will work.

whitevans1

07-15-2007 09:12 PM

when i try to uninstall i get this

Database error in vBulletin 3.6.7:

Invalid SQL:
ALTER TABLE post DROP COLUMN `icash`;

MySQL Error : Can't DROP 'icash'; check that column/key exists
Error Number : 1091
Date : Sunday, July 15th 2007 @ 06:12:31 PM
Script : http://www.run3h4x.net/forum/admincp...do=productkill
Referrer : http://www.run3h4x.net/forum/admincp...uctid=Icash&s=
IP Address :
Username :
Classname : vb_database

Blaine0002

07-15-2007 09:28 PM

Sorry you had to get caught up in that, That SHOULD be the last error you get, NOW.

Re download the current XML, Import/overwrite your previous one since you cant uninstall, THEN uninstall it, you should not recieve any errors. Now that it is uninstalled install it one last time and I think your good to go.

whitevans1

07-15-2007 09:36 PM

It won't unistall for some reason... I get the same error and i downloaded the newest one.

Database error in vBulletin 3.6.7:

Invalid SQL:
ALTER TABLE forum DROP COLUMN `icash_prethread`;

MySQL Error : Can't DROP 'icash_prethread'; check that column/key exists
Error Number : 1091
Date : Sunday, July 15th 2007 @ 06:36:32 PM
Script : http://www.run3h4x.net/forum/admincp...do=productkill
Referrer : http://www.run3h4x.net/forum/admincp...uctid=Icash&s=
IP Address :
Username :
Classname : vb_database

SKULL1985

07-15-2007 09:39 PM

I have installed this on my forum 3.6.7 but when you make a post , thread no one gets any points?

All times are GMT. The time now is 12:45 PM.

Page 83 of 119

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02079 seconds Memory Usage 1,745KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: