vb.org Archive - Major Additions - microCART: Shopping System for vB4

Page 66 of 85

« First

Last »

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

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)

Christos Teriakis

10-22-2011 05:43 PM

Quote:

Originally Posted by JimL (Post 2260071)

anyone else get these? I get 5-10 of them every once in a while

Code:

Database error in vBulletin 4.1.7:



Invalid SQL:

UPDATE vb_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  : Saturday, October 22nd 2011 @ 10:27:48 AM

Error Date    : Saturday, October 22nd 2011 @ 10:27:50 AM

Script        : /cart_gateway.php?method=paypal

Referrer      :

Username      :

Classname     : vB_Database

MySQL Version :

The value of userid is missing.

Chris

JimL	10-22-2011 07:56 PM

Quote:

Originally Posted by ChrisTERiS (Post 2260232)

Both are wrong:D The query is not completed. Is missing a ." to close the userid=
Try this:

Code:

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

Chris

Ok, will report back. The original quote was from the standard
cart_gateway.php file though..

are you sure this is correct? doesn't it have to be something like

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

Quote:

Originally Posted by ChrisTERiS (Post 2260236)

The value of userid is missing.

Chris

Proobably because the sql-query in question was wrong? :P

Christos Teriakis

10-23-2011 04:36 AM

Quote:

Originally Posted by JimL (Post 2260287)

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

Yes, that's correct. I focused only in the part of userid.

Chris

Germantin

10-27-2011 03:11 AM

Thanks for this great Mod, I have a couple questions or issues. When someone buys something from my site they have to fill in the name, address etc. This info never clears for the next person to buy something. Also the paypal link does not work, when you click on pay with paypal a broken link comes up. It use to work not sure what happened there. Any help would be great.

Thanks,
Steven

Scyther

10-27-2011 08:40 AM

One of the best mods i came thru...

Marked installed...

Keysailor

11-01-2011 07:12 PM

Quote:

Originally Posted by Easy5s.net (Post 2259224)

When I click Payment, it fails this

Invalid Redirect URL (https://www.paypal.com/cgi-bin/websc...ethod%3Dpaypal)

I was getting that too, until I read and followed the instructions which said to create at least one agreement. Once I did that, that error went away and I got a normal paypal checkout window. Who'd a'thunk that paypal verification (even for items that don't have a MicroCart agreement) won't work without at least one agreement in place!

Cheers!
Keysailor

p.s., also to create the upload directory and reflect it in the options. I did both these at once, so I'm not 100% sure which (or if both) was what fixed the Paypal payment issue.

CrimsonRayne

11-08-2011 01:45 PM

Hey,

I'm getting exactly the same error with the application.

I've added in an agreement (and changed a product to use that agreement) and also added in a valid download URL. I can upload files fine, but it still gives me the error. I've even tried to make a basic sub where a member will be promoted to another user group, and it still doesn't work.

Any ideas? I'm running VB 4.1.7 (patch level 2)

I've specified the path as c:\onlinestore\ and set permissions to everyone. Still no joy?

AndyP

11-09-2011 12:08 AM

Did you add paypal to your whitelist of websites in the vbulletin options?

DoDe	11-09-2011 07:13 AM

Is this mod coded 100% XHTML 1.0 Transitional valid?

rdavm

11-14-2011 05:34 AM

Very well done shopping cart, THANKS a lot for this one :)

All times are GMT. The time now is 10:31 AM.

Page 66 of 85

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01942 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 (2)bbcode_code_printable (5)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: