vb.org Archive - Major Additions - vbBux / vbPlaza v1.5.8 (Points + Store System)

Database error in vBulletin 3.5.2:

Invalid SQL:

UPDATE estoreitems
SET
active = '1', changealways = '0', showinstore = '1', loghistory = '1', category = '7', name = 'Primary Usergroup', description = 'This will allow you to buy a primary usergroup for more features.', displayorder = '24', cost = '20000', tax = '13.50000', expirydate = '0', refilldateline = '0', defquantity = '20', quantity = '20', sold = '0', allowedgroups = '6', deniedgroups = '', imagelocation = 'images/estore/primaryusergoup.png', scriptlocation = 'estore/action.primaryusergroup.php', tablename = 'usergroup', wherename = '', wherevalue = '', settype = '0', setname = '', setvalue = '', inputfields = 'a:0:{}'
WHERE itemid = '34';

MySQL Error : Unknown column 'changealways' in 'field list'
Error Number : 1054
Date : Saturday, February 11th 2006 @ 11:17:51 PM
Script : http://forums.xxx.com/admincp/estore.php
Referrer : http://forums.xxx.com/admincp/estore...tion&itemid=34
IP Address : xxx
Username : admin
Classname : vb_database

dirtycrow

02-12-2006 02:20 AM

Quote:

Originally Posted by Ignignokt

estore_main will require a revert

how do i do that ? :ermm: i won't let me, revert is grayed out.

Ignignokt

02-12-2006 02:23 AM

Quote:

Originally Posted by dirtycrow

how do i do that ? :ermm: i won't let me, revert is grayed out.

Since it is greyed out, it mean's you did not alter it and it won't need to be reverted.

dirtycrow

02-12-2006 02:23 AM

any idea about the error i'm getting in post 1202? thanks.

lordofgun

02-12-2006 02:31 AM

After update on 1.1.1 - happened when i tried to set the values for store option change profile picture.

Quote:

Database error in vBulletin 3.5.3:

Invalid SQL:

UPDATE estoreitems
SET
active = '1', changealways = '0', showinstore = '1', loghistory = '1', category = '8', name = 'Change Profile Picture', description = 'This will allow you to upload your own profile picture.', displayorder = '42', cost = '1000', tax = '6.75000', expirydate = '0', refilldateline = '0', defquantity = '20', quantity = '20', sold = '0', allowedgroups = '2,5,6,7,12,13,14,15', deniedgroups = '', imagelocation = 'images/estore/changeprofilepicture.png', scriptlocation = 'estore/action.changeprofilepicture.php', tablename = 'user', wherename = '', wherevalue = '', settype = '0', setname = '', setvalue = '', inputfields = 'a:0:{}'
WHERE itemid = '47';

MySQL Error : Unknown column 'changealways' in 'field list'
Error Number : 1054
Date : Saturday, February 11th 2006 @ 11:29:56 PM
Script : http://www.billszone.com/fanzone/admincp/estore.php
Referrer : http://www.billszone.com/fanzone/adm...tion&itemid=47
IP Address :
Username :
Classname : vb_database

dirtycrow

02-12-2006 02:33 AM

Quote:

Originally Posted by lordofgun

After update on 1.1.1 - happened when i tried to set the values for store option change profile picture.

i'm getting the same error :(

lordofgun

02-12-2006 02:34 AM

yep. is happening when I try to edit any store option.

CMX_CMGSCCC

02-12-2006 02:37 AM

Quote:

Originally Posted by dirtycrow

any template changes between v1.0.9 and v1.1.1?

A small one if you want to show the amount in people's banks and their total points in the postbit and memberinfo.

Quote:

Originally Posted by lordofgun

After update on 1.1.1 - happened when i tried to set the values for store option change profile picture.

Fixed in v1.1.1.1 (small typo oops heh)

If you updated to v1.1.1, you must update to v1.1.1.1 to fix the changeaways typo.

-CMX

Roxie

02-12-2006 02:45 AM

getting the same error since upgrade...

All times are GMT. The time now is 04:47 AM.

Page 121 of 401

121

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03838 seconds Memory Usage 1,746KB 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 (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (6)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: