Thread: Major Additions - microCART: Shopping System for vB4
View Single Post
  #179  
Old 02-01-2011, 06:06 PM
micheal332001 micheal332001 is offline
 
Join Date: Apr 2004
Posts: 1,112
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by peppefark View Post
I installed the mod! When I go in the user groups to give permissions, after confirming I get this error message:

Code:
Database error
The Club Alfa Romeo Cuore Sportivo Italia database has encountered a problem.

Database error in vBulletin 4.0.8:

Invalid SQL:
UPDATE vb_usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
    `title` = 'Amministratore',
    `description` = 'Amministratore',
    `usertitle` = 'Amministratore',
    `opentag` = '<span style=\"color: #FF0000;\">',
    `closetag` = '</span>',
    `passwordexpires` = '180',
    `passwordhistory` = '360',
    `dtogaragepermissions` = '1',
    `dtogaragesize` = '3',
    `medialibperms` = '63',
    `medialibmodperms` = '63',
    `ms_imageshack_upload_permissions` = '0',
    `vbblog_general_permissions` = '524286',
    `vbblog_customblocks` = '10',
    `vbblog_custompages` = '10',
    `vbblog_entry_permissions` = '32767',
    `vbblog_comment_permissions` = '2014',
    `dbtech_vbshoutpermissions` = '2',
    `forumpermissions` = '16777215',
    `genericpermissions` = '2147483583',
    `attachlimit` = '0',
    `pmquota` = '50',
    `pmpermissions` = '7',
    `pmsendmax` = '5',
    `pmthrottlequantity` = '0',
    `calendarpermissions` = '63',
    `wolpermissions` = '31',
    `adminpermissions` = '3',
    `genericpermissions2` = '1',
    `genericoptions` = '55',
    `profilepicmaxwidth` = '100',
    `profilepicmaxheight` = '100',
    `profilepicmaxsize` = '65535',
    `avatarmaxwidth` = '80',
    `avatarmaxheight` = '80',
    `avatarmaxsize` = '20000',
    `signaturepermissions` = '245759',
    `sigpicmaxwidth` = '500',
    `sigpicmaxheight` = '100',
    `sigpicmaxsize` = '10000',
    `sigmaxrawchars` = '0',
    `sigmaxchars` = '0',
    `sigmaxlines` = '0',
    `sigmaxsizebbcode` = '7',
    `sigmaximages` = '0',
    `albumpermissions` = '255',
    `albumpicmaxwidth` = '600',
    `albumpicmaxheight` = '600',
    `albummaxpics` = '100',
    `albummaxsize` = '0',
    `usercsspermissions` = '63',
    `visitormessagepermissions` = '63',
    `socialgrouppermissions` = '262143',
    `maximumsocialgroups` = '5',
    `groupiconmaxsize` = '65535',
    `microcart` = '7'
WHERE usergroupid=6;

MySQL Error   : Unknown column 'ms_imageshack_upload_permissions' in 'field list'
Error Number  : 1054
Request Date  : Sunday, January 30th 2011 @ 04:16:34 PM
Error Date    : Sunday, January 30th 2011 @ 04:16:34 PM
Script        : http://www.clubcuoresportivo.it/admincp/usergroup.php?do=update
Referrer      : http://www.clubcuoresportivo.it/admincp/usergroup.php?do=edit&usergroupid=6
IP Address    : 79.3.169.152
Username      : peppefark
Classname     : vB_Database
MySQL Version : 5.0.91-enterprise-gpl-log
Please help me to solve this problem!

Thanks
this is your problem here

MySQL Error : Unknown column 'ms_imageshack_upload_permissions' in 'field list'

this table is not there it might be form an old mod you have installed and then removed or it was never added when you installed this mod.
I can tell you this is not down to the microcart system.

Quote:
Originally Posted by jgt58 View Post
could you add in a PM notification to a selectable admin when a new order is created?

and is there a paid version where I could take your copyright off?
Yes this can be sorted out so it will PM/Email an admin.

Quote:
Originally Posted by Halfhidden View Post
This is a superior product... I love it.
We use Paypal a lot here in the UK because it is the cheapest gateway for payment. I set up my paypal email address in the admin section and tried a test purchase.
I noticed that after a member has filled in the personal details for the sale and click on check out they are redirected to PayPal. Here they are asked to either log in or fill out the exact same details as they did on the VB site. Can the personal details be populated to the PayPal checkout?
Also is there any way to set up either "express check out" or "Website payment Pro" with PayPal. Both need to have API's set up with the cart but members who buy don't actually leave the site and everything integrates very well.
I'll happily pay for this extra integration if need be

This is a wonderful script and I would like to thank you for ALL of your hard work and dedication to supporting it... Thank You!:up::up:
I do see what you mean and will be sorting out some sort of system for this at some time.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01116 seconds
  • Memory Usage 1,793KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete