I'm not sure how to solve (long time ago ;-) ... Two posibilities:
First check SQL query in main.php. Should like like:
$item_result = db_query("SELECT DISTINCT item.*, iteminfo.* from item, iteminfo, it_itgr
WHERE (item.itemgrID='$itemgr' OR (it_itgr.itemgrID='$itemgr' AND it_itgr.itemID=item.ID))
AND iteminfo.itemID= item.ID AND iteminfo.langID='$langID' AND item.visible='1'
order by item.orderby") or db_die(17);
Or insert following into new table it_itgr:
INSERT INTO it_itgr (itemID, itemgrID) VALUES (-1,-1)
Andreas.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Maybe we need hundreds of postings to remove all difference between 2.0 and 2.02.
1) Please install a clean 2.02 independent from your existing installation
2) Have a look at http://www.mysqldiff.org
Download and install their tool. It compares databases and writes SQL commands.
3) Backup your existing install.
4) Run commands by msqldiff on old database.
Other way is to check all tables by hand ...
Most things are the same, but not all ;-)
Greetings,
Andreas.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Your item has now price or price is equal zero.
There is an option in configuration, to show such prices or not ("Show prices, which are 0.00").
In config file its variable is name $show_null.
If $show_null==0 a text from language file shown instead of 0.00 ($null_text).
Note: If price is lighter then zero $gratis is used.
Greetings,
Andreas.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I tried to upgrade version 2.0 to 2.02, but I got the following message:
Table 'shop.it_itgr' doesn't exist17
What should I do?
Krisztin
Send following SQL command to databse of phPay:
CREATE TABLE `it_itgr` (
`ID` int(8) NOT NULL auto_increment,
`itemID` int(8) NOT NULL default '0',
`itemgrID` int(8) NOT NULL default '0',
PRIMARY KEY (`ID`)
) TYPE=MyISAM;
In phpAdmin or similar.
Andreas.
Thanks, it worked. But now I can't see any items, only itemgroups.
Krisztin
I'm not sure how to solve (long time ago ;-) ... Two posibilities:
First check SQL query in main.php. Should like like:
$item_result = db_query("SELECT DISTINCT item.*, iteminfo.* from item, iteminfo, it_itgr
WHERE (item.itemgrID='$itemgr' OR (it_itgr.itemgrID='$itemgr' AND it_itgr.itemID=item.ID))
AND iteminfo.itemID= item.ID AND iteminfo.langID='$langID' AND item.visible='1'
order by item.orderby") or db_die(17);
Or insert following into new table it_itgr:
INSERT INTO it_itgr (itemID, itemgrID) VALUES (-1,-1)
Andreas.
I got further :-)
Now I can see only the first item in each itemgroup.
Another problem is it can't display price and no. of items:
Price: on request
No. of items: Unknown column 'size.aktiv' in 'where clause'
Krisztin
Maybe we need hundreds of postings to remove all difference between 2.0 and 2.02.
1) Please install a clean 2.02 independent from your existing installation
2) Have a look at http://www.mysqldiff.org
Download and install their tool. It compares databases and writes SQL commands.
3) Backup your existing install.
4) Run commands by msqldiff on old database.
Other way is to check all tables by hand ...
Most things are the same, but not all ;-)
Greetings,
Andreas.
This worked (almost) fine ;-)
Now one thing is missing: at the price column I see "on request". What can this be?
Thanks!
Fine :-)
Your item has now price or price is equal zero.
There is an option in configuration, to show such prices or not ("Show prices, which are 0.00").
In config file its variable is name $show_null.
If $show_null==0 a text from language file shown instead of 0.00 ($null_text).
Note: If price is lighter then zero $gratis is used.
Greetings,
Andreas.