vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Major Additions - eCommerce for vB4.2.2+ (https://vborg.vbsupport.ru/showthread.php?t=316501)

pratul11 01-13-2017 05:54 AM

How do I access the store front page after adding products in the back end?

Whenever I am trying to access it from http://www.occultforums.net/cart.php, it says you do not have permission to access this page.

I am the super Admin of the site. What should I do?

TheAdminMarket 01-13-2017 07:47 AM

Really can't understand how some users act here. For something that is mark as "Unsupported" to post 3 messages in forums and on the same time to send them as PM. Not even to wait some hours.

pratul11 01-13-2017 12:15 PM

Hi
I have installed the eCommerce for vB4.2.2+ Mod . I have installed the product in my vBulletin version 4.2.3.
But I am facing a problem here. I have added a Category and products in that category. I am clicking on the product, it is taking me back to the forum homepage. What should I do ? I can't go to the products details page for ordering...
please check the screenshot of the shop in my forum...

https://snag.gy/gYoDNf.jpg

Please help..thanks

pratul11 01-16-2017 06:17 AM

Hello Sorry about this..I was in hurry..
I am looking for some support...i don't know how to contact you for support...so PMed u as your site is not working...
the mod is creating some problems to me during installation. So I thought of uninstalling and reinstalling it...but while uninstalling it, I got this error:

Database error in vBulletin 4.2.3:

Invalid SQL:
DROP TABLE `ecommerce_news`;

MySQL Error : Unknown table 'ecommerce_news'
Error Number : 1051
Request Date : Monday, January 16th 2017 @ 08:09:13 AM
Error Date : Monday, January 16th 2017 @ 08:09:13 AM
Script : http://www.occultforums.net/admincp/...do=productkill
Referrer : http://www.occultforums.net/admincp/...d=ecommerce&s=
IP Address : 103.10.197.4
Username : DarkAdverts
Classname : vB_Database
MySQL Version : 5.5.52-cll-lve

HM666 01-16-2017 08:32 PM

After a little bit of research I have found a fix for the category upload icon issue as mentioned above by pratul11 I too had the same issue so I googled it and found a fix for it. To fix this PHP Warning message:

Quote:

Originally Posted by pratul11
PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2792

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2832

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2859

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2886

PHP Warning: preg_match(): Compilation failed: invalid range in character class at offset 7 in ..../ecommerce/includes/class.upload.php on line 2904

You will need to have a HTML editor. DO NOT USE MS WORD!!! You will need to edit the code within a file to fix this, so if you are not comfy with that then perhaps you should hire someone or ask a friend that is comfy with it....whichever. ALWAYS MAKE A BACK UP OF THE FILE YOU ARE WORKING WITH. :)

Open your /ecommerce/includes/class.upload.php in your HTML editor and look for line 2792 and find:

Code:

if (preg_match("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", $this->file_src_mime)) {
                                $this->file_src_mime = preg_replace("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", '$1/$2', $this->file_src_mime);
                                $this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Replace it with:

Code:

if (preg_match("/^([\w.-]+)\/([\w.-]+)(.*)$/i", $this->file_src_mime)) {
                                $this->file_src_mime = preg_replace("/^([\w.-]+)\/([\w.-]+)(.*)$/i", '$1/$2', $this->file_src_mime);
                                $this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Then look for line 2832 and look for this:

Code:

if (preg_match("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", $this->file_src_mime)) {
                                    $this->file_src_mime = preg_replace("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", '$1/$2', $this->file_src_mime);
                                    $this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Then replace it with this:

Code:

if (preg_match("/^([\w.-]+)\/([\w.-]+)(.*)$/i", $this->file_src_mime)) {
                                    $this->file_src_mime = preg_replace("/^([\w.-]+)\/([\w.-]+)(.*)$/i", '$1/$2', $this->file_src_mime);
                                    $this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Then go to line 2859 and find:

Code:

if (preg_match("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", $this->file_src_mime)) {
                            $this->file_src_mime = preg_replace("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", '$1/$2', $this->file_src_mime);
                            $this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

And replace it with:

Code:

if (preg_match("/^([\w.-]+)\/([\w.-]+)(.*)$/i", $this->file_src_mime)) {
                            $this->file_src_mime = preg_replace("/^([\w.-]+)\/([\w.-]+)(.*)$/i", '$1/$2', $this->file_src_mime);
                            $this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Then find line 2886 and find:

Code:

if (preg_match("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", $this->file_src_mime)) {
                            $this->file_src_mime = preg_replace("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", '$1/$2', $this->file_src_mime);
                            $this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

And replace it with:

Code:

if (preg_match("/^([\w.-]+)\/([\w.-]+)(.*)$/i", $this->file_src_mime)) {
                            $this->file_src_mime = preg_replace("/^([\w.-]+)\/([\w.-]+)(.*)$/i", '$1/$2', $this->file_src_mime);
                            $this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Then find line 2904 and find:

Code:

if (preg_match("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", $this->file_src_mime)) {
                    $this->file_src_mime = preg_replace("/^([\.-\w]+)\/([\.-\w]+)(.*)$/i", '$1/$2', $this->file_src_mime);
                    $this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

And replace it with:

Code:

if (preg_match("/^([\w.-]+)\/([\w.-]+)(.*)$/i", $this->file_src_mime)) {
                    $this->file_src_mime = preg_replace("/^([\w.-]+)\/([\w.-]+)(.*)$/i", '$1/$2', $this->file_src_mime);
                    $this->log .= '-&nbsp;MIME validated as ' . $this->file_src_mime . '<br />';

Save the file and upload it overwriting the other file.

Mind you I'm not a PHP coder. I do design, HTML & CSS. So if you have intricate PHP questions I may or may not be able to answer them. But I found this fix and it worked for my site,possibly it will help others.

pratul11 01-17-2017 05:30 AM

Hi All: I have got a new issue. I have uninstalled the mod completely and then tried reinstalling it..now I get the following error:


Database error in vBulletin 4.2.3:

Invalid SQL:
INSERT INTO `ecommerce_product_types` SET id='1', name='Downloadable', shipping='0', downloads='1';

MySQL Error : Duplicate entry '1' for key 'PRIMARY'
Error Number : 1062
Request Date : Friday, January 13th 2017 @ 06:39:33 AM
Error Date : Friday, January 13th 2017 @ 06:39:34 AM
Script : http://www.occultforums.net/admincp/...=productimport
Referrer : http://www.occultforums.net/admincp/...?do=productadd
IP Address : 103.10.197.2
Username : DarkAdverts
Classname : vB_Database
MySQL Version : 5.5.52-cll-lve

Can you please help me how to solve it? Thanks

HM666 01-17-2017 06:39 AM

Quote:

Originally Posted by pratul11 (Post 2580961)
Hi All: I have got a new issue. I have uninstalled the mod completely and then tried reinstalling it..now I get the following error:


Database error in vBulletin 4.2.3:

Invalid SQL:
INSERT INTO `ecommerce_product_types` SET id='1', name='Downloadable', shipping='0', downloads='1';

MySQL Error : Duplicate entry '1' for key 'PRIMARY'
Error Number : 1062
Request Date : Friday, January 13th 2017 @ 06:39:33 AM
Error Date : Friday, January 13th 2017 @ 06:39:34 AM
Script : http://www.occultforums.net/admincp/...=productimport
Referrer : http://www.occultforums.net/admincp/...?do=productadd
IP Address : 103.10.197.2
Username : DarkAdverts
Classname : vB_Database
MySQL Version : 5.5.52-cll-lve

Can you please help me how to solve it? Thanks

That is because when you uninstalled it did not uninstall the database as well. So basically what that error message is saying is that there was already a value for that table in your database and therefore it cannot install until that value is removed. If you have phpMyAdmin you can go into it and remove that table or the tables associated with the ecommerce module and try to reinstall it again. Just be careful because if you remove the wrong thing it can completely and permanently screw up your forum. Your ecommerce tables will labeled as ecommerce_agreements, ecommerce_cart and so on. Every table that has ecommerce_ in it will belong to this mod. Your tables may have a prefix. It depends on what was done when vBulletin was installed. My prefix is vb4 so an eccomerce table in mine would look like vb4_eccommerce_cart.

pratul11 01-17-2017 11:32 AM

Thanks a lot HM666!

HM666 01-17-2017 03:37 PM

No problem.

secondeye 02-21-2017 09:23 AM

is it still working as DEMO link not working: ttp://www.teriakis.com/vb423/cart.php


All times are GMT. The time now is 05:22 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.01312 seconds
  • Memory Usage 1,787KB
  • 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
  • (10)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)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