vb.org Archive
Page 40 of 85 « First 303839 40 414250 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   IShop - Simple, Flexible, and Integrateable. (https://vborg.vbsupport.ru/showthread.php?t=109515)

Err0r404 05-02-2007 06:34 PM
oh im also gettign this error

Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE itemshop_stock
SET iorder =
CASE
ELSE uid
END
WHERE uid IN ();

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 'ELSE uid
END
WHERE uid IN ()' at line 4
Error Number : 1064
Date : Wednesday, May 2nd 2007 @ 02:33:06 PM
Script : http://www.the-pr0xz.com/forums/isho...=doupdateorder
Referrer : http://www.the-pr0xz.com/forums/ishop.php
IP Address : Xx.XXx.XxX.
Username : Err0r404
Classname : vb_database


any ideas?

4newbies 05-02-2007 11:18 PM
Still need help with the following:

Does this replace Ultra Itemshop by the same developer? If not, what are the differences?

Also, I have installed iCash mod to my forum to work with iShop system. However, I don't really need to sell images that will showup in user's postbit. What I need is a page where people can redeem the points they have earned for real prizes and money. Like they go to the redemption page and say they want to purchase a mug with their points. Then the system deducts the points and notifies me that a user has purchased a mug. Is this possible to do with iShop?

So how often does the developer show up on this thread? Maybe him or someone else has some tips about how this can be done. I guess the more important priority for me at this point is to have the mod send a notification PM or automated post in the staff area every time someone purchases an item from the shop. This way I know instantly when I need to award a prize to someone.
Edit/Delete Message

It's been 7 days since my original post and no help. Are there any other Point / Store system alternatives available that I can download from somewhere?

AzzidReign 05-03-2007 12:46 PM
Not yet, but I've been informed that there will be. I'm keeping my eye out for it. I believe the point system will be called "PointIt", so you can be on the look out. I'll assume that the bank and store and labeled "StoreIt" and "BankIt"...but I'm only guessing.

jonnycrick 05-04-2007 12:20 AM
Quote:
Originally Posted by Err0r404 (Post 1239964)
oh im also gettign this error

Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE itemshop_stock
SET iorder =
CASE
ELSE uid
END
WHERE uid IN ();

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 'ELSE uid
END
WHERE uid IN ()' at line 4
Error Number : 1064
Date : Wednesday, May 2nd 2007 @ 02:33:06 PM
Script : http://www.the-pr0xz.com/forums/isho...=doupdateorder
Referrer : http://www.the-pr0xz.com/forums/ishop.php
IP Address : Xx.XXx.XxX.
Username : Err0r404
Classname : vb_database


any ideas?
I'm getting the same error too. Help appreciated!

Let me know if you work it out ;)

Susp3nc3 05-05-2007 12:27 AM
Any thought of putting up a message while giving a gift! other than that this thing is awesome! Only needs the personalized messages and it would be even cooler.

deezelpope 05-05-2007 09:52 AM
My members either send PMs or reputation to notify the recipient.

MissKalunji 05-05-2007 09:30 PM
same as mine

rabbits slayer 05-06-2007 09:08 AM
I get these errors when pressing the "update order" button:

Code:
Warning: Invalid argument supplied for foreach() in /ishop.php on line 95

Warning: array_keys() [function.array-keys]: The first argument should be an array in /ishop.php on line 100

Warning: implode() [function.implode]: Bad arguments. in /ishop.php on line 100
This only happen when there's nothing in inventory. Help pls? Other than that, it works fine.

MissKalunji 05-07-2007 12:29 AM
database error

Code:
Invalid SQL:

      UPDATE itemshop_stock
      SET iorder =
          CASE
                      WHEN uid = 8 THEN
                      WHEN uid = 9 THEN
                      WHEN uid = 11 THEN
                      WHEN uid = 19 THEN
                      WHEN uid = 21 THEN
                      WHEN uid = 31 THEN
                      WHEN uid = 50 THEN
                      WHEN uid = 69 THEN
                      WHEN uid = 75 THEN
                      WHEN uid = 76 THEN
                      WHEN uid = 88 THEN 1
              ELSE uid
          END
      WHERE uid IN (8,9,11,19,21,31,50,69,75,76,88);

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 'WHEN uid = 9 THEN
                      WHEN uid = 11 THEN
                      WHEN uid = 19 THEN
Error Number : 1064
Date        : Sunday, May 6th 2007 @ 11:51:21 AM
Script      : http://www.dancehallareaz.com/forum/ishop.php?do=doupdateorder

rungok 05-08-2007 09:02 AM
Is it possible to identify who the donation is from in CP or shop?


All times are GMT. The time now is 07:07 PM.
Page 40 of 85 « First 303839 40 414250 Last »
Show 40 post(s) from this thread on one page

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.02006 seconds
  • Memory Usage 1,747KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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