vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - microCART: Shopping System for vB4 (https://vborg.vbsupport.ru/showthread.php?t=256723)

micheal332001 01-06-2011 10:00 PM

microCART: Shopping System for vB4
 
1 Attachment(s)
microCART is a fully featured Shopping Cart for vBulletin 4.x, with support for Downloadable & Pysical Products, Subscriptions and Services, without missing any feature even from commercial scripts. Installation is very easy, you just need sometime for the initial configuration.

Edit: Please note - Currently this mod is only compatible with vBulletin 4.1.9 and below, if your using vBulletin 4.1.10 then the modifications current version released here (1.1.4) is not suggested for use. - TheLastSuperman

1.- Highlights
  • Supports Downloadable products
  • Since version 1.0.3 supports Physical products too!!
  • Supports Subscriptions (Even Reccuring)
  • Supports Services
  • Ability to upgrade usergroup per product
  • Unlimited depth levels of categories
  • Unlimited Products
  • Supports Renewals
  • Ability to Add Orders manually
  • PayPal & 2CO payments
  • Since version 1.0.4 support payments with ccBill (Credits to kastak)
  • Supports AddOns
  • Support Special Deals
  • Unlimited Screenshoots per product
  • Unlimited Files per product, so the customers can download previous versions
  • Unlimited Agreements
  • Customers (and only those who have bought that product) can rate and review it.
  • Admin can turn On/Off the Reviews per product
  • Uses HTML Editor.
  • Since version 1.0.5 support multiple Tax levels.
  • Since version 1.0.5 support Shipping Zones with unlimited shipping choices per zone.
  • Since version 1.0.5 supports Delivery locations (unlimited depth, eg Country, State, Area with different setup for Tax and Shipping per category.
  • Since version 1.0.5 customer must enter his details to finalize the order.
  • NEW!! Since version 1.0.6 supports Auto Tax calculation.
  • NEW!! Since version 1.0.6 supports Auto Shipping calculation.
  • NEW!! Since version 1.0.5 supports Invoice creation.
  • NEW!! Comming Soon Block.
2.- Installation
  • Download and unzip microCART.zip file
  • Upload all the files in your site keeping the same structure. eg cart.php must be on the same level as your forum.php
  • CMOD 777 the directories:
    • microcart
    • microcart/photos
    • microcart/photos/thumbs
    • microcart/photos/tmp
    • microcart/editor/files
    • microcart/editor/flash
    • microcart/editor/media
    • microcart/editor/photos
    • microcart/pdf
    • microcart/fonts
    • microcart/images
  • Login to your admincp and import product-microcart.xml
3.- Configuration
  • First of all you need to setup microCART General Options. The most important option is to set the path to the directory where you'll store the files. For security reasons you must create a directory over the public area. Then write the full path in the options. Don't forget the trailing slash at the end. Example:
    • /home/username/downloads/
  • Setup Usergroup permissions. Available options are:
    • Can access the store
    • Can order
    • Can Moderate. Please note that, as a way to bypass the limitation of having vB editor in admincp, I've moved the product descriprion, system messages and agreements to fronend. But only those who can moderate can access this area, and only for modifying the text. Nothing more.
  • Setup Categories and Subcategories for your store.
  • Setup your Agreements (at least one)
  • Start adding products but from AddOns and Services. It will helps you to save time, as when at a later time you add a main product, you can choose the addons.
  • To work properly with HTML editor you need to edit settings.php locating at: microcart/editor/assetmanager/ and set the corrects paths.
4.- Product Options (Configurations)

In version 1.0.3 has been added support for configurable options. Not just simple text choices, but options that can increase/decrease the total price. That's why you need to pay extra attention on entering these options to avoid pricing mess.

First of all, you can find these options as "Extra Options" on the droplist on the right of each product (AdminCP). By choosing it you'll get a list of all available configurable options for the specific product. You can Edit and Delete it, or you can change the display order. Click "New Extra Option" to add one.

There is no need for explanation of title. Write there anything that you want. Examples of configuration options are: Color, Size, Ram, Hard disk etc. So let's write Size. In the box below you must add all the available options keeping the format:
Amount|Name

Examples:
  • 0|Normal : This option dosen't changes the product's price and it will appears as: Normal
  • 15.30|Large : This option increases the price by 15.30 and it will appears as: Large (+$15.30) ... The currency symbol is the one that you've setup. DON'T NEED TO ENTER CURRENCY SYMBOL HERE
  • -7.50|Mini : This option decreases the price by 7.50 and it will appears as: Mini (-$7.50). ONCE MORE: DONT ADD CURRENCY SYMBOL.
5.- Product Terminology
  • Price: Is the normal price that you're selling a product (eg 49.95)
  • Discount: Is the amount that you're giving as discount. eg if you place 4.95 here the price will appear as $49.95 $45.00
  • Special (Bundle) price. Currently not in use
  • AddOns. Are products that someone can order in the same form (eg Installation, Brand Free etc).
  • Special Bundle. Currently not in use
6.- Understanding Shipping Zones
To understand Shipping fields (Base weight, Base fare, Extra weight, Extra fare), you must know how the companies (at least the most of them) are working. They're saying: Till 3 kilos the rate is $15. More than 3 kilos you must add $3 per 500gr (1/2 kilos). In this example you must setup:
  1. Base weight 3000 (in grammars) or 3 (in kilos)
  2. Base fare 15.00
  3. Extra weight 500 (in grammars) or 0.5 (in kilos)
  4. Extra fare 3.00
  5. Please note to use the same as the definied in the general option weight unit. Setting in options kgr and here grammars is the best way to mess your shop.
7.- Friedly notes
  • Please let my copyright link in place. Thank you.
  • When rating, please remember that you're rating the script and not me as a person. Thank you.
  • Don't spam this thread with comments about my personality. Comment my work only. Thank you.
8.- Demo9.- Warning

The included HTML Editor is commercial, so you can use it ONLY within microCART directory.


UPGRADING

To upgrade just upload the new files then follow
2.- Installationwith Allow Overwrite set to YES


CHANGE LOG

  • Added Comming Soon Block
  • Added view users invoice within admincp
  • Added usergroup controled discounts
  • Added stock level control
  • Added coupon system
  • Changed the invoice system to work better.
  • Added forum home side block. (Download the product-microcart_forum_block.xml and Install like a new product)
  • MICROCART_114_01022011.zip has no affects added to my account
  • MICROCART_114_240211.zip has a fade in affect on my accounts pages.
  • added some java for the my accounts page and the product view page. So you dont have to re-fresh the page all the time. Updated: 28/02/2011
  • Fixed the problem with the euro within the add-on options.
BUG FIX
  • Fixed error within the admin php file on line 23.
  • Updated the forum side block ( Please let me know if you are still having problems with this. Updated Date 22nd Fed 2011)
  • fixed problem with the prices. UPDATED Date 22nd Apr 2011 to upgrade just upload the files as its only the cart.php and microcart/functions.php files that have been updated.
  • Fixed problem with the add-ons prices. Updated 25th Apr 2011 to upgrade just upload the cart.php file
  • cart.php updated again to fix the problem with the add-ons when changing the qty within the cart.
  • Fixed problem with edit invoices in admincp
  • Fixed a problem with large price formats.
  • Fixed problem with option prices (11-05-2011)
  • Updated the files for the new editor not tested Updated 13/06/2011.
Arabic Language File Download Here

nacaruncr 01-07-2011 07:18 PM

what are the diference between this theme and this other https://vborg.vbsupport.ru/showthread.php?t=249601 ??
Because I see them are the same...

benstillman 01-07-2011 07:31 PM

Quote:

Originally Posted by nacaruncr (Post 2145591)
what are the diference between this theme and this other https://vborg.vbsupport.ru/showthread.php?t=249601 ??
Because I see them are the same...

1.1.1 vs 1.1.4? Looks like just an update?

And BTW, the URL http://www.microhellas.com/vb4demo/cart.php isn't work. http://www.microhellas.com isn't working either. It redirects to http://www.foromail.com.

akxt660 01-08-2011 01:56 AM

Hello!

Where is the XML file? I get and error when i update from v.1.1.1.

Database error in vBulletin 4.0.3:
Invalid SQL:
SELECT * FROM fxt_microcart_usercoupon WHERE userid=9 AND valid=3;

MySQL Error : Table 'akk_fakk.fxt_microcart_usercoupon' doesn't exist
Error Number : 1146
Request Date : Saturday, January 8th 2011 @ 01:51:34 AM
Error Date : Saturday, January 8th 2011 @ 01:51:34 AM
Script : http://website.com/cart.php
Referrer :
IP Address : 180.199.184.73
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.0.91-community

Teascu Dorin 01-08-2011 02:10 AM

Can you please post a Change log to know what's new in latest version?
Thanks!

Preech 01-08-2011 05:43 AM

I think this is great. I have a valid license for the one that I bought from Vbcover, but this one looks a little better to me in my personal opinion.

micheal332001 01-08-2011 05:53 AM

Quote:

Originally Posted by xt660.com.br (Post 2145766)
Hello!

Where is the XML file? I get and error when i update from v.1.1.1.

Database error in vBulletin 4.0.3:
Invalid SQL:
SELECT * FROM fxt_microcart_usercoupon WHERE userid=9 AND valid=3;

MySQL Error : Table 'akk_fakk.fxt_microcart_usercoupon' doesn't exist
Error Number : 1146
Request Date : Saturday, January 8th 2011 @ 01:51:34 AM
Error Date : Saturday, January 8th 2011 @ 01:51:34 AM
Script : http://website.com/cart.php
Referrer :
IP Address : 180.199.184.73
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.0.91-community

Hi there

seems that the coupon database table did not get installed you can add this manuly or you could uninstall the cart and try installing it again to make sure all the tables get added.

If you would like me to fix this for you then please PM me with admincp access and FTP details.

micheal332001 01-08-2011 06:05 AM

Quote:

Originally Posted by nacaruncr (Post 2145591)
what are the diference between this theme and this other https://vborg.vbsupport.ru/showthread.php?t=249601 ??
Because I see them are the same...


The diference is that i have taken over this product from maria.
This is why she has not given support for this within that thread as i have the full rights over this product now.

Same product but with alot more added from marias version.

micheal332001 01-08-2011 06:06 AM

Quote:

Originally Posted by dorin2oo7 (Post 2145780)
Can you please post a Change log to know what's new in latest version?
Thanks!

Done m8

micheal332001 01-08-2011 06:07 AM

Quote:

Originally Posted by Preech (Post 2145846)
I think this is great. I have a valid license for the one that I bought from Vbcover, but this one looks a little better to me in my personal opinion.


Thankyou so much.

Hornstar 01-09-2011 07:47 AM

This looks very good. Very impressed with how many features this has.

Dadoo 01-09-2011 08:48 AM

Hi Micheal, it appears product-microcart.xml is missing in your archive..

So, it's not said in your topic, but in fact, we have to download microCart 1.1.1 from this topic, then download your archive (update29122001.zip) and update the product.

Am i right ?

EDIT : I have that error when i try to acces to any link starting by : microcart_admin.php?do=***

Quote:

Parse error: syntax error, unexpected $end in localhost\admincp\microcart_admin.php on line 2218
2218 is the last line of this file..

Exactly same problem than Adem Genc

I tried in local with Wamp and Xamp (differents versions of Apache, PHP and Mysql, same result..)

wh1t3dr3am 01-09-2011 02:01 PM

Hi Micheal,why i got an error like this?How to fix it ? Thx :D
Code:

SELECT * FROM microcart_usercoupon WHERE userid=1 AND valid=1;

MySQL Error  : Table 'ogiazic_vbulletin.microcart_usercoupon' doesn't exist


Dadoo 01-09-2011 04:39 PM

I don't understand....

I've an DB error who said :

PHP Code:

Invalid SQL:
INSERT INTO vb411microcart_products
                                           SET categoryid 
'1',
                                               
name 'Test product',
                                               
type '1',
                                               
status '1',
                                               
code '',
                                               
manufacturer '',
                                               
description 'Content of test product',
                                               
features 'custom text <span style=\"font-weight: bold;\">bold text</span><span style=\"font-weight: bold;\">Second test</span>
'
,
                                               
price '130',
                                               
discountprice '10',
                                               
specialprice '20',
                                               
renewal '0',
                                               
license '1',
                                               
dlperiod '365',
                                               
demolink '',
                                               
forumlink 'http://localhost/showthread.php?1-pr%E9sentation-du-dadoo',
                                               
bugslink 'http://localhost/showthread.php?1-pr%E9sentation-du-dadoo',
                                               
reviews '1',
                                               
agreement '0',
                                               
frontpage '1',
                                               
flagship '1',
                                               
isbundle '0',
                                               
addons '',
                                               
extras '0',
                                               
promousergroup '0',
                                               
weight '700',
                                               
image 'admincp0.jpg',
                                                          
userstocklevel '1',
                                                          
stocklevel '0',
                                                          
discount_usergroups '';

MySQL Error   Unknown column 'userstocklevel' in 'field list' 

When i look XML product file, i see :

PHP Code:

        CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."microcart_products` (
          `
idint(11NOT NULL auto_increment,
          `
namevarchar(100NOT NULL,
          `
categoryidint(11NOT NULL,
          `
typetinyint(1NOT NULL default '1',
          `
statusint(11NOT NULL default '1',
          `
codevarchar(100NOT NULL,
          `
manufacturervarchar(100NOT NULL,
          `
pricedecimal(10,2NOT NULL default '0.00',
          `
discountpricedecimal(10,2NOT NULL default '0.00',
          `
specialpricedecimal(10,2NOT NULL default '0.00',
          `
renewaldecimal(10,2NOT NULL default '0.00',
          `
descriptionmediumtext NOT NULL,
          `
featuresmediumtext NOT NULL,
          `
forumlinkvarchar(50NOT NULL,
          `
demolinkvarchar(50NOT NULL,
          `
bugslinkvarchar(150NOT NULL,
          `
licenseint(11NOT NULL,
          `
dlperiodint(11NOT NULL,
          `
addonsvarchar(255NOT NULL,
          `
extrasint(5NOT NULL default '0',
          `
promousergroupint(11NOT NULL,
          `
agreementtinyint(1NOT NULL default '0',
          `
reviewstinyint(1NOT NULL default '0',
          `
isbundletinyint(1NOT NULL default '0',
          `
frontpagetinyint(1NOT NULL default '0',
          `
flagshiptinyint(1NOT NULL default '0',
          `
imagevarchar(30NOT NULL,
          
PRIMARY KEY  (`id`),
          
KEY `categoryid` (`categoryid`),
          
KEY `name` (`name`)
        ) 
ENGINE=MyISAM
        
"); 

It seems followings tables are missing into installation file..

PHP Code:

userstocklevel '1',
stocklevel '0',
discount_usergroups ''


micheal332001 01-09-2011 05:19 PM

Quote:

Originally Posted by Dadoo (Post 2146352)
Hi Micheal, it appears product-microcart.xml is missing in your archive..

So, it's not said in your topic, but in fact, we have to download microCart 1.1.1 from this topic, then download your archive (update29122001.zip) and update the product.

Am i right ?

EDIT : I have that error when i try to acces to any link starting by : microcart_admin.php?do=***

2218 is the last line of this file..

Exactly same problem than Adem Genc

I tried in local with Wamp and Xamp (differents versions of Apache, PHP and Mysql, same result..)

I will have a look at the code and XML file to make sure every thing is right.

Quote:

Originally Posted by wh1t3dr3am (Post 2146443)
Hi Micheal,why i got an error like this?How to fix it ? Thx :D
Code:

SELECT * FROM microcart_usercoupon WHERE userid=1 AND valid=1;

MySQL Error  : Table 'ogiazic_vbulletin.microcart_usercoupon' doesn't exist


I will look into it

Quote:

Originally Posted by Dadoo (Post 2146513)
I don't understand....

I've an DB error who said :

PHP Code:

Invalid SQL:
INSERT INTO vb411microcart_products
                                           SET categoryid 
'1',
                                               
name 'Test product',
                                               
type '1',
                                               
status '1',
                                               
code '',
                                               
manufacturer '',
                                               
description 'Content of test product',
                                               
features 'custom text <span style=\"font-weight: bold;\">bold text</span><span style=\"font-weight: bold;\">Second test</span>
'
,
                                               
price '130',
                                               
discountprice '10',
                                               
specialprice '20',
                                               
renewal '0',
                                               
license '1',
                                               
dlperiod '365',
                                               
demolink '',
                                               
forumlink 'http://localhost/showthread.php?1-pr%E9sentation-du-dadoo',
                                               
bugslink 'http://localhost/showthread.php?1-pr%E9sentation-du-dadoo',
                                               
reviews '1',
                                               
agreement '0',
                                               
frontpage '1',
                                               
flagship '1',
                                               
isbundle '0',
                                               
addons '',
                                               
extras '0',
                                               
promousergroup '0',
                                               
weight '700',
                                               
image 'admincp0.jpg',
                                                          
userstocklevel '1',
                                                          
stocklevel '0',
                                                          
discount_usergroups '';

MySQL Error   Unknown column 'userstocklevel' in 'field list' 

When i look XML product file, i see :

PHP Code:

        CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."microcart_products` (
          `
idint(11NOT NULL auto_increment,
          `
namevarchar(100NOT NULL,
          `
categoryidint(11NOT NULL,
          `
typetinyint(1NOT NULL default '1',
          `
statusint(11NOT NULL default '1',
          `
codevarchar(100NOT NULL,
          `
manufacturervarchar(100NOT NULL,
          `
pricedecimal(10,2NOT NULL default '0.00',
          `
discountpricedecimal(10,2NOT NULL default '0.00',
          `
specialpricedecimal(10,2NOT NULL default '0.00',
          `
renewaldecimal(10,2NOT NULL default '0.00',
          `
descriptionmediumtext NOT NULL,
          `
featuresmediumtext NOT NULL,
          `
forumlinkvarchar(50NOT NULL,
          `
demolinkvarchar(50NOT NULL,
          `
bugslinkvarchar(150NOT NULL,
          `
licenseint(11NOT NULL,
          `
dlperiodint(11NOT NULL,
          `
addonsvarchar(255NOT NULL,
          `
extrasint(5NOT NULL default '0',
          `
promousergroupint(11NOT NULL,
          `
agreementtinyint(1NOT NULL default '0',
          `
reviewstinyint(1NOT NULL default '0',
          `
isbundletinyint(1NOT NULL default '0',
          `
frontpagetinyint(1NOT NULL default '0',
          `
flagshiptinyint(1NOT NULL default '0',
          `
imagevarchar(30NOT NULL,
          
PRIMARY KEY  (`id`),
          
KEY `categoryid` (`categoryid`),
          
KEY `name` (`name`)
        ) 
ENGINE=MyISAM
        
"); 

It seems followings tables are missing into installation file..

PHP Code:

userstocklevel '1',
stocklevel '0',
discount_usergroups ''


I will check this as it would not be there as it would be in the upgrade code.
I'll have to look at the XML file before I can tell what's up.

WEBDosser 01-09-2011 05:32 PM

tagged

Dadoo 01-10-2011 03:24 AM

Quote:

Originally Posted by micheal332001 (Post 2146522)
I will check this as it would not be there as it would be in the upgrade code.
I'll have to look at the XML file before I can tell what's up.

Thanks a lot Micheal, otherwise i have finished French translation of microCART 1.1.4.

I have to verify some details and then i will release it.
Is it possible to put the XML file in first post for a better visibility ?

micheal332001 01-10-2011 05:59 AM

Quote:

Originally Posted by Dadoo (Post 2146821)
Thanks a lot Micheal, otherwise i have finished French translation of microCART 1.1.4.

I have to verify some details and then i will release it.
Is it possible to put the XML file in first post for a better visibility ?

I should have the fix for this later today and will re-upload it when done and let you all know when its ready.

And yes m8 when you release it in a post i will then add it to the top for everyone to see.

micheal332001 01-10-2011 06:58 AM

Sorry all i did forget to put the product xml file within the zip file but its there now.

micheal332001 01-10-2011 07:05 AM

Hi all

Im sorry for the problems you had with the missing product xml file.
I have now uploaded the new files with the product xml file within the zip file now.

If you installed version says it version 1.1.4 change this to version to 1.1.1 and then import the product xml file with overright set to yes.
This will then installed version 1.1.4 and put the new database tables in.

If you have the table name stocklevel within the database table microcart_products then change the version to 1.1.2

If you have the table name discount_usergroups and stocklevel within the database table microcart_products then change the version to 1.1.3

If you have the database tables microcart_coupon and microcart_usercoupon and the above already there then you dont need to change the version.

your24hourstore 01-10-2011 02:24 PM

thanx great product ,,love it

GamerPerfection 01-10-2011 04:41 PM

Tagged.

Raffaele 01-10-2011 05:47 PM

where is the product xml file located i just downloaded the microCart_1_1_4_update_29122001 and i don't see the file

Dadoo 01-10-2011 06:09 PM

1 Attachment(s)
Quote:

Originally Posted by micheal332001 (Post 2146877)
And yes m8 when you release it in a post i will then add it to the top for everyone to see.

Done :-)

Micheal, in this zip archive, you will find 2 files :

1 : French language exported from product
2 : /upload/admincp/microcart_admin.php (because there is plenty of phrases untranslated inside, admincp side only)

I let you decide what files are to include or not :-)

micheal332001 01-10-2011 06:12 PM

Quote:

Originally Posted by Raffaele (Post 2147131)
where is the product xml file located i just downloaded the microCart_1_1_4_update_29122001 and i don't see the file

This is the new files with the product xml file

microCart_1_1_4_12012011.zip

GamerPerfection 01-11-2011 07:27 PM

I've installed it all.
It shows up on my website, and in the AdminCP it shows up. I click on General Options and is fine. But all other options from Categories to Add Coupon I get this error:

Quote:

Parse error: syntax error, unexpected $end in C:\xampp\htdocs\admincp\microcart_admin.php on line 2775

Lomak 01-11-2011 08:01 PM

is there any way to stop people ordering an item if the stock level reaches 0 ?

Lomak 01-11-2011 09:42 PM

when someone purchases something in the store i get this error:
i think Paypal is trying to talk back to the store... I don't use coupons and customer data is mandatory and all field were filled in...


Code:

Database error in vBulletin 4.1.0:

Invalid SQL:
UPDATE microcart_usercoupon SET valid=0 WHERE userid=;

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 '' at line 1
Error Number  : 1064
Request Date  : Tuesday, January 11th 2011 @ 11:31:27 PM
Error Date    : Tuesday, January 11th 2011 @ 11:31:29 PM
Script        : http://mysite.com/cart_gateway.php?method=paypal
Referrer      :
IP Address    : 66.211.170.66
Username      :
Classname    : vB_Database
MySQL Version :


Lomak 01-12-2011 10:24 AM

An invoice is created even if the transaction / payment is not completed... can this be changed?

Because of this it is hard to tie up the real invoice from the fake... (lots of people have been pressing checkout, etc. before doing the REAL transaction

So, can the unique(?) ID of the transaction , e.g. User Name-DDMmmYY-ABC1DEF2G3 that is shown on the Paypal invoice be duplicated on the microCART invoice (AdminCP and User Invoice)?


Thanks in Advance

Helmut71 01-12-2011 01:12 PM

is there a German version of this?

Dadoo 01-12-2011 02:51 PM

Quote:

Originally Posted by GamerPerfection (Post 2147683)
I've installed it all.
It shows up on my website, and in the AdminCP it shows up. I click on General Options and is fine. But all other options from Categories to Add Coupon I get this error:

It appears that neither Xamp or Wamp are working with microCART. I've tested both of them with many configurations (apache, php, mysql with differents versions and differents file edits) and no luck..

Quote:

Originally Posted by Helmut71 (Post 2147997)
is there a German version of this?

You mean translated in german or available on vbulletin-germany.com ? Both no but you can translate it in german if you want..?

ckgreenman 01-13-2011 01:16 AM

I'm unable to get product photos to load. I've followed the installation described in post. The photo is uploaded and there are no erros, but it doesn't show up when viewed via cart.php

Any suggestions?

GamerPerfection 01-13-2011 05:59 AM

Quote:

Originally Posted by Dadoo (Post 2148057)
It appears that neither Xamp or Wamp are working with microCART. I've tested both of them with many configurations (apache, php, mysql with differents versions and differents file edits) and no luck..

Damn, so much for testing it out on my test site using Xampp.

Lomak 01-13-2011 07:15 AM

with regards to my previous post about paypal contacting , ihave now had an email from them...

Is this something i need to configure?

Code:

Hello,

Please check your server that handles PayPal Instant Payment Notifications (IPN). IPNs sent to the following URL(s) are failing:

http://mysite.com/cart_gateway.php?method=paypal

If you do not recognize this URL, you may be using a service provider that is using IPN on your behalf. Please contact your service provider with the above information. If this problem continues, IPNs may be disabled for your account.

Thank you for your prompt attention to this issue.


Thanks,

PayPal


micheal332001 01-13-2011 07:24 AM

Quote:

Originally Posted by GamerPerfection (Post 2147683)
I've installed it all.
It shows up on my website, and in the AdminCP it shows up. I click on General Options and is fine. But all other options from Categories to Add Coupon I get this error:

Try re-uploading the files as it might have uploaded the files wrong the first time.

Quote:

Originally Posted by Lomak (Post 2147688)
is there any way to stop people ordering an item if the stock level reaches 0 ?

When the stock level gets to 0 it should hide the order button i will look into this for you.

Quote:

Originally Posted by Lomak (Post 2147734)
when someone purchases something in the store i get this error:
i think Paypal is trying to talk back to the store... I don't use coupons and customer data is mandatory and all field were filled in...


Code:

Database error in vBulletin 4.1.0:

Invalid SQL:
UPDATE microcart_usercoupon SET valid=0 WHERE userid=;

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 '' at line 1
Error Number  : 1064
Request Date  : Tuesday, January 11th 2011 @ 11:31:27 PM
Error Date    : Tuesday, January 11th 2011 @ 11:31:29 PM
Script        : http://mysite.com/cart_gateway.php?method=paypal
Referrer      :
IP Address    : 66.211.170.66
Username      :
Classname    : vB_Database
MySQL Version :


This looks like a non-member has tryed to order from the shop system and thats why the userid is blank.

Quote:

Originally Posted by Lomak (Post 2147962)
An invoice is created even if the transaction / payment is not completed... can this be changed?

Because of this it is hard to tie up the real invoice from the fake... (lots of people have been pressing checkout, etc. before doing the REAL transaction

So, can the unique(?) ID of the transaction , e.g. User Name-DDMmmYY-ABC1DEF2G3 that is shown on the Paypal invoice be duplicated on the microCART invoice (AdminCP and User Invoice)?


Thanks in Advance

All invoices are made when the user goes to the payment gateway.
If the trancation is not completed it will show them within the invoice that payment has not been made.

And when viewing the invoices within the admincp it will show you if that invoice has been paid or shipped.

Quote:

Originally Posted by Helmut71 (Post 2147997)
is there a German version of this?

Not at this time but if you would like to do this please feel free to do so.

micheal332001 01-13-2011 07:29 AM

Quote:

Originally Posted by Dadoo (Post 2148057)
It appears that neither Xamp or Wamp are working with microCART. I've tested both of them with many configurations (apache, php, mysql with differents versions and differents file edits) and no luck..

I have tested this and this works on these system as i use these for testing my self.

Quote:

Originally Posted by ckgreenman (Post 2148257)
I'm unable to get product photos to load. I've followed the installation described in post. The photo is uploaded and there are no erros, but it doesn't show up when viewed via cart.php

Any suggestions?

Please send me a PM with admincp login details and i will have alook for you.
Also please send FTP login as i can check that everything is set right as well.

Quote:

Originally Posted by Lomak (Post 2148332)
with regards to my previous post about paypal contacting , ihave now had an email from them...

Is this something i need to configure?

Code:

Hello,

Please check your server that handles PayPal Instant Payment Notifications (IPN). IPNs sent to the following URL(s) are failing:

http://mysite.com/cart_gateway.php?method=paypal

If you do not recognize this URL, you may be using a service provider that is using IPN on your behalf. Please contact your service provider with the above information. If this problem continues, IPNs may be disabled for your account.

Thank you for your prompt attention to this issue.


Thanks,

PayPal


The IPN is already set for you and this is not the problem its down to the userid that was sent in your last post showing that there was no userid sent and this is why you got the error.

Lomak 01-13-2011 07:30 AM

Quote:

Originally Posted by micheal332001 (Post 2148335)
All invoices are made when the user goes to the payment gateway.
If the trancation is not completed it will show them within the invoice that payment has not been made.

And when viewing the invoices within the admincp it will show you if that invoice has been paid or shipped.

Thanks,

But just for us to double check manually, and for peace of mind before shipment of goods.. would it be possible to have the unique number in the invoice system?

User Name-DDMmmYY-ABC1DEF2G3


Thanks!

Lomak 01-13-2011 07:32 AM

Quote:

Originally Posted by micheal332001 (Post 2148336)

The IPN is already set for you and this is not the problem its down to the userid that was sent in your last post showing that there was no userid sent and this is why you got the error.

I have had LOTS of errors... all from registered members...

for every transaction i get the previous SQL error...

micheal332001 01-13-2011 08:01 AM

Quote:

Originally Posted by Lomak (Post 2148337)
Thanks,

But just for us to double check manually, and for peace of mind before shipment of goods.. would it be possible to have the unique number in the invoice system?

User Name-DDMmmYY-ABC1DEF2G3


Thanks!

Yes this can be added and will be within next release i hope.
That will be within 1.1.5 version.

Quote:

Originally Posted by Lomak (Post 2148340)
I have had LOTS of errors... all from registered members...

for every transaction i get the previous SQL error...

I will check this out.

micheal332001 01-13-2011 08:49 AM

Have re-uploaded all files for version 1.1.4 and these have been tested and are working right.
As for paypal sending back to the gateway i cannot test this but if you are having this error with the coupons please remove this line of code from the cart_gateway.php file

line no: 76
PHP Code:

$db->query_write("UPDATE ".TABLE_PREFIX."microcart_usercoupon SET valid=0 WHERE userid=".$user['userid']); 



All times are GMT. The time now is 05:13 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02264 seconds
  • Memory Usage 2,047KB
  • 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
  • (6)bbcode_code_printable
  • (7)bbcode_php_printable
  • (29)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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