vb.org Archive
Page 2 of 85 1 2 341252 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)

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` (
          `id` int(11) NOT NULL auto_increment,
          `name` varchar(100) NOT NULL,
          `categoryid` int(11) NOT NULL,
          `type` tinyint(1) NOT NULL default '1',
          `status` int(11) NOT NULL default '1',
          `code` varchar(100) NOT NULL,
          `manufacturer` varchar(100) NOT NULL,
          `price` decimal(10,2) NOT NULL default '0.00',
          `discountprice` decimal(10,2) NOT NULL default '0.00',
          `specialprice` decimal(10,2) NOT NULL default '0.00',
          `renewal` decimal(10,2) NOT NULL default '0.00',
          `description` mediumtext NOT NULL,
          `features` mediumtext NOT NULL,
          `forumlink` varchar(50) NOT NULL,
          `demolink` varchar(50) NOT NULL,
          `bugslink` varchar(150) NOT NULL,
          `license` int(11) NOT NULL,
          `dlperiod` int(11) NOT NULL,
          `addons` varchar(255) NOT NULL,
          `extras` int(5) NOT NULL default '0',
          `promousergroup` int(11) NOT NULL,
          `agreement` tinyint(1) NOT NULL default '0',
          `reviews` tinyint(1) NOT NULL default '0',
          `isbundle` tinyint(1) NOT NULL default '0',
          `frontpage` tinyint(1) NOT NULL default '0',
          `flagship` tinyint(1) NOT NULL default '0',
          `image` varchar(30) NOT 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` (
          `id` int(11) NOT NULL auto_increment,
          `name` varchar(100) NOT NULL,
          `categoryid` int(11) NOT NULL,
          `type` tinyint(1) NOT NULL default '1',
          `status` int(11) NOT NULL default '1',
          `code` varchar(100) NOT NULL,
          `manufacturer` varchar(100) NOT NULL,
          `price` decimal(10,2) NOT NULL default '0.00',
          `discountprice` decimal(10,2) NOT NULL default '0.00',
          `specialprice` decimal(10,2) NOT NULL default '0.00',
          `renewal` decimal(10,2) NOT NULL default '0.00',
          `description` mediumtext NOT NULL,
          `features` mediumtext NOT NULL,
          `forumlink` varchar(50) NOT NULL,
          `demolink` varchar(50) NOT NULL,
          `bugslink` varchar(150) NOT NULL,
          `license` int(11) NOT NULL,
          `dlperiod` int(11) NOT NULL,
          `addons` varchar(255) NOT NULL,
          `extras` int(5) NOT NULL default '0',
          `promousergroup` int(11) NOT NULL,
          `agreement` tinyint(1) NOT NULL default '0',
          `reviews` tinyint(1) NOT NULL default '0',
          `isbundle` tinyint(1) NOT NULL default '0',
          `frontpage` tinyint(1) NOT NULL default '0',
          `flagship` tinyint(1) NOT NULL default '0',
          `image` varchar(30) NOT 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.


All times are GMT. The time now is 06:32 AM.
Page 2 of 85 1 2 341252 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.01906 seconds
  • Memory Usage 1,893KB
  • 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
  • (6)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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