Page 2 of 6
Posted: Thu 16. Aug 2007, 13:32
by juergen
found this in sql shop setup:
Code: Select all
ENGINE=MyISAM DEFAULT CHARSET=latin1;
and this version is alll utf-8 .....
Lets see if thats the reason why it dosn't accept any preferencs..
Posted: Thu 16. Aug 2007, 14:08
by flip-flop
DF6IH wrote:found this in sql shop setup:
Code: Select all
ENGINE=MyISAM DEFAULT CHARSET=latin1;
and this version is alll utf-8 .....
Lets see if thats the reason why it dosn't accept any preferencs..
Where did you find this exactly? For me there is only one file called setup.php containing the SQL tables (commented).
Knut
Posted: Thu 16. Aug 2007, 14:27
by juergen
hers this shop_sql.sql that came with my version :
Code: Select all
-- phpMyAdmin SQL Dump
-- version 2.8.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Erstellungszeit: 03. August 2007 um 07:57
-- Server Version: 4.1.13
-- PHP-Version: 5.0.5
--
-- Datenbank: `usr_web2_1`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `phpwcms_categories`
--
CREATE TABLE `phpwcms_categories` (
`cat_id` int(10) unsigned NOT NULL auto_increment,
`cat_type` varchar(255) NOT NULL default '',
`cat_status` int(1) NOT NULL default '0',
`cat_createdate` datetime NOT NULL default '0000-00-00 00:00:00',
`cat_changedate` datetime NOT NULL default '0000-00-00 00:00:00',
`cat_name` varchar(255) NOT NULL default '',
`cat_info` text NOT NULL,
PRIMARY KEY (`cat_id`),
KEY `cat_type` (`cat_type`,`cat_status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `phpwcms_shop_orders`
--
CREATE TABLE `phpwcms_shop_orders` (
`order_id` int(10) unsigned NOT NULL auto_increment,
`order_number` varchar(20) NOT NULL default '',
`order_date` datetime NOT NULL default '0000-00-00 00:00:00',
`order_name` varchar(255) NOT NULL default '',
`order_firstname` varchar(255) NOT NULL default '',
`order_email` varchar(255) NOT NULL default '',
`order_net` float NOT NULL default '0',
`order_gross` float NOT NULL default '0',
`order_payment` varchar(255) NOT NULL default '',
`order_data` mediumtext NOT NULL,
`order_status` varchar(100) NOT NULL default '',
PRIMARY KEY (`order_id`),
KEY `order_number` (`order_number`,`order_status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `phpwcms_shop_products`
--
CREATE TABLE `phpwcms_shop_products` (
`shopprod_id` int(10) unsigned NOT NULL auto_increment,
`shopprod_createdate` datetime NOT NULL default '0000-00-00 00:00:00',
`shopprod_changedate` datetime NOT NULL default '0000-00-00 00:00:00',
`shopprod_status` int(1) unsigned NOT NULL default '0',
`shopprod_uid` int(10) unsigned NOT NULL default '0',
`shopprod_ordernumber` varchar(255) NOT NULL default '',
`shopprod_model` varchar(255) NOT NULL default '',
`shopprod_name1` varchar(255) NOT NULL default '',
`shopprod_name2` varchar(255) NOT NULL default '',
`shopprod_tag` varchar(255) NOT NULL default '',
`shopprod_vat` float unsigned NOT NULL default '0',
`shopprod_netgross` int(1) unsigned NOT NULL default '0',
`shopprod_price` float NOT NULL default '0',
`shopprod_maxrebate` float NOT NULL default '0',
`shopprod_description0` text NOT NULL,
`shopprod_description1` text NOT NULL,
`shopprod_description2` text NOT NULL,
`shopprod_description3` text NOT NULL,
`shopprod_var` mediumtext NOT NULL,
`shopprod_category` varchar(255) NOT NULL default '',
`shopprod_weight` float NOT NULL default '0',
`shopprod_color` varchar(255) NOT NULL default '',
`shopprod_size` varchar(255) NOT NULL default '',
PRIMARY KEY (`shopprod_id`),
KEY `shopprod_status` (`shopprod_status`),
KEY `category` (`shopprod_category`),
KEY `tag` (`shopprod_tag`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `phpwcms_sysvalue`
--
CREATE TABLE `phpwcms_sysvalue` (
`sysvalue_key` varchar(255) NOT NULL default '',
`sysvalue_group` varchar(255) NOT NULL default '',
`sysvalue_lastchange` int(11) NOT NULL default '0',
`sysvalue_status` int(1) NOT NULL default '0',
`sysvalue_vartype` varchar(100) NOT NULL default '',
`sysvalue_value` text NOT NULL,
PRIMARY KEY (`sysvalue_key`),
KEY `sysvalue_group` (`sysvalue_group`),
KEY `sysvalue_status` (`sysvalue_status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Posted: Thu 16. Aug 2007, 14:46
by rushclub
i am installed the shop succsessfull but i have no chance to add categories or products. any other with these problems? the frontend works fine.
rush
Posted: Thu 16. Aug 2007, 15:02
by Oliver Georgi
shop works with 1.3.5 only - you cannot use the module on any older release.
Oliver
Posted: Thu 16. Aug 2007, 15:15
by rushclub
i am using it in 1.3.5. any ideas?
rush
Posted: Thu 16. Aug 2007, 15:52
by flip-flop
@rush: Are all tables installed posted by DF6IH?
@nekket: The SQL file include/inc_module/mod_shop/setup/shop_sql.sql
wasn´t there for me. I don´t know why.
I have had inserted only the table phpwcms_shop_orders from the file setup.php.
Please insert the missing tables into yout db and it will run. (charset at the end of every table !!!)
@DF6IH: Thanks for this hint.
Knut
Posted: Thu 16. Aug 2007, 15:53
by sustia
rushclub wrote:i am using it in 1.3.5. any ideas?
rush
Hi, do you have some message error in the backend?
For me that error was due to an incomplete installation (missing to execute a part of the sql file).
The only area in the backend that doesn't work is the "Preferences area".
How to work with the shop?
Posted: Thu 16. Aug 2007, 16:23
by krailing
Am I stupid? I'm unable to find a way to handle with shop module. I first loaded an earlier version (trunk-03-08-2007), and there was no sql-file, now I copied the mod_shop folder into the inc_module. Run the setup.php? Does not work. I created the tables in the db with the shop_sql.sql. Going to the backend and to Module/Shop, there is nothing happening. What am I doing wrong?
Krake
Posted: Thu 16. Aug 2007, 16:26
by Oliver Georgi
phpwcms_sysvalue table has to be upgraded too.
Oliver
Posted: Thu 16. Aug 2007, 16:39
by sustia
Oliver Georgi wrote:phpwcms_sysvalue table has to be upgraded too.
Oliver
Yeeeesss
This is what I see in the backend
Posted: Thu 16. Aug 2007, 16:41
by krailing
ok, thanks, Oliver. Got a little problem with the database and don't want to start a mess: can I delete the old phpwcms_sysvalue table and create the new one or must it exactly be an update?
Krake
Posted: Thu 16. Aug 2007, 16:42
by juergen
Tattaaaaaaaaaa
http://dl0wh.de/test/index.php?index
you are allowed to shop ...
I deleted the old sysvalue and brought in the new:
Code: Select all
CREATE TABLE `phpwcms_sysvalue` (
`sysvalue_key` varchar(255) NOT NULL default '',
`sysvalue_group` varchar(255) NOT NULL default '',
`sysvalue_lastchange` int(11) NOT NULL default '0',
`sysvalue_status` int(1) NOT NULL default '0',
`sysvalue_vartype` varchar(100) NOT NULL default '',
`sysvalue_value` text NOT NULL,
PRIMARY KEY (`sysvalue_key`),
KEY `sysvalue_group` (`sysvalue_group`),
KEY `sysvalue_status` (`sysvalue_status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Big job oliver !!!![/code]
seems like sustia was the first phpwcms "Kaufhaus"
Posted: Thu 16. Aug 2007, 16:53
by sustia
I'm doing a beer checkout in your site
Module/Shop still empty
Posted: Thu 16. Aug 2007, 16:54
by krailing
Thanks, but in my backend/Module/Shop/Proukte is still empty, nothing happening. Should there appear something? I have no idea what to do.
I am thankful for any help....
Krake