[micheal332001]

Originally Posted by Dadoo

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.

Originally Posted by wh1t3dr3am

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

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

Originally Posted by Dadoo

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.