phpwcms Support Forum

The phpwcms support forum will help to find answers to your questions. The small but strong community is here since more than 10 years.
https://forum.phpwcms.org/

<Solved>How to setup shop module for phpwcms 1.3.5

https://forum.phpwcms.org/viewtopic.php?t=15803

Page 1 of 2

<Solved>How to setup shop module for phpwcms 1.3.5

Posted: Sat 6. Oct 2007, 10:46
by sunny123
why I use shop module and include\inc_module\mod_shop\setup\setup.php is blank?
Could anyone teach me step by step?
Thank you!
I can't read other language!

Posted: Sun 7. Oct 2007, 16:16
by FN-Media
Delete Folder : .../include/inc_module/mod_shop/setup

Edit .../config/phpwcms/conf.inc.php Add Code:

$phpwcms['SESSION_FEinit'] = 1; // set 1 to enable sessions in frontend, 0 to disable sessions in frontend

$phpwcms['Login_IPcheck'] = 0;

Open Database with phpmyadmin or other tool

Run SQL:

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=utf8;


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`)
) TYPE = MYISAM DEFAULT CHARSET=utf8;

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 '',
`shopprod_listall` int(1) unsigned NOT NULL default '0',
PRIMARY KEY (`shopprod_id`),
KEY `shopprod_status` (`shopprod_status`),
KEY `category` (`shopprod_category`),
KEY `tag` (`shopprod_tag`),
KEY `all` (`shopprod_listall`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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=utf8;

ALTER TABLE `phpwcms_categories` ADD `cat_pid` INT( 11 ) NOT NULL AFTER `cat_type` ;
ALTER TABLE `phpwcms_categories` ADD INDEX ( `cat_pid` ) ;

thats all.

sorry, my smale english is very bad. :D

Posted: Mon 8. Oct 2007, 02:31
by sunny123
FN-Media wrote:Delete Folder : .../include/inc_module/mod_shop/setup

Edit .../config/phpwcms/conf.inc.php Add Code:
.......
Thank FN-Media!
my phpmyadmin show error:"#1050 - Table 'phpwcms_sysvalue' already exists " when I run sql, how?

Posted: Mon 8. Oct 2007, 15:54
by sunny123
why no answer?

Posted: Mon 8. Oct 2007, 16:11
by flip-flop
my phpmyadmin show error:"#1050 - Table 'phpwcms_sysvalue' already exists " when I run sql, how?
Mhh, the answer is showing in the error message. If this table exists, it is ok.
Please run the next part in phpMyAdmin:

Code: Select all

ALTER TABLE `phpwcms_categories` ADD `cat_pid` INT( 11 ) NOT NULL AFTER `cat_type` ;
ALTER TABLE `phpwcms_categories` ADD INDEX ( `cat_pid` ) ;
and insert/switch in conf.inc.php

Code: Select all

$phpwcms['SESSION_FEinit'] = 1; // set 1 to enable sessions in frontend, 0 to disable sessions in frontend

$phpwcms['Login_IPcheck'] = 0;
Knut

Posted: Tue 9. Oct 2007, 01:22
by sunny123
flip-flop wrote:
my phpmyadmin show error:"#1050 - Table 'phpwcms_sysvalue' already exists " when I run sql, how?
Mhh, the answer is showing in the error message. If this table exists, it is ok. ..................
But how to do about

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=utf8;
??????
It does not need? :?:

Posted: Tue 9. Oct 2007, 03:28
by sunny123
May I delete the original `phpwcms_sysvalue`in database?

Posted: Tue 9. Oct 2007, 06:03
by juergen
sunny123 wrote:May I delete the original `phpwcms_sysvalue`in database?
Yes, you may ;)

And then redo :

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`)
)
and all works fine

Posted: Wed 10. Oct 2007, 02:26
by sunny123
DF6IH wrote:
sunny123 wrote:May I delete the original `phpwcms_sysvalue`in database?
Yes, you may ;)..................and all works fine
Thank you!

Can't change settings

Posted: Thu 25. Oct 2007, 17:12
by zelsyus
I've done the steps as given in this thread here three times now...
...and still I can't change the settings for the shop (currency, tax, ...).

I can add categories, products. That's working just fine.

What is wrong?

Posted: Tue 30. Oct 2007, 11:09
by design
Hello!
I'm trying to install shop module in 2007/10/29 version.
There is a mysql error:

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 11

How can I solve it?
Thanks!

Posted: Tue 30. Oct 2007, 11:15
by juergen
design wrote:Hello!

#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 11

How can I solve it?
Thanks!
leave the complete "DEFAULT........" away from the sql syntax

Posted: Tue 30. Oct 2007, 11:21
by design
Thank you!
Now it works!

Posted: Tue 30. Oct 2007, 11:40
by design
Nooooo!
I can't create a new category.
the error is:

inc_module/mod_shop/inc/listing.categories.inc.php on line 214

Code: Select all

foreach($data as $row)
This can be connected with the charset?
The post about this was in german! :roll:

Re: <Solved>How to setup shop module for phpwcms 1.3.5

Posted: Fri 7. Mar 2008, 16:37
by nebenaube
Greetings, I just upgraded a site from 1.3.3 to 1.3.5 and I am trying to install the shop module.
as noted above, the tables needed to be created so I took the sql file from setup and modified a copy of the setup.php that is in the banner module so as to install the required database tables.

This is the second pass.

Code: Select all

<?php


// do everything in here which is neccessary for module setup

// ceate neccessary db table
$sql = array();

//on edit: integrated the following statements into create statement:
//ALTER TABLE `phpwcms_categories` ADD `cat_pid` INT( 11 ) NOT NULL AFTER `cat_type` ;
//ALTER TABLE `phpwcms_categories` ADD INDEX ( `cat_pid` ) ; 
// made sure that db_prepend was actually matching other tables in the database, note extra '_' if applicable


$sql[0] = "DROP TABLE ".$phpwcms["db_prepend"]."_phpwcms_categories;";
echo $sql[0]."<br />\n";

$sql[1] = "CREATE TABLE ".$phpwcms["db_prepend"]."_phpwcms_categories (
						  `cat_id` int(10) unsigned NOT NULL auto_increment,
						  `cat_type` varchar(255) NOT NULL default '',
                                                  `cat_pid` int(11) NOT NULL,
						  `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`),
                                                  INDEX(`cat_pid`),
						  KEY `cat_type` (`cat_type`,`cat_status`)
					      ) ENGINE=MyISAM DEFAULT CHARSET=utf8;";

echo $sql[1]."<br />\n";

$sql[2] = "DROP TABLE ".$phpwcms["db_prepend"]."_phpwcms_shop_orders;";
echo $sql[2]."<br />\n";

$sql[3] = "CREATE TABLE ".$phpwcms["db_prepend"]."_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=utf8;";

echo $sql[3]."<br />\n";

$sql[4] = "DROP TABLE ".$phpwcms["db_prepend"]."_phpwcms_shop_products;";
echo $sql[4]."<br />\n";

$sql[5] = "CREATE TABLE ".$phpwcms["db_prepend"]."_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 '',
						  `shopprod_listall` int(1) unsigned NOT NULL default '0',
						  PRIMARY KEY  (`shopprod_id`),
						  KEY `shopprod_status` (`shopprod_status`),
						  KEY `category` (`shopprod_category`),
						  KEY `tag` (`shopprod_tag`),
						  KEY `all` (`shopprod_listall`)
						) ENGINE=MyISAM DEFAULT CHARSET=utf8;";

echo $sql[5]."<br />\n";


$sql[6] = "DROP TABLE ".$phpwcms["db_prepend"]."_phpwcms_sysvalue;";
echo $sql[6]."<br />\n";

$sql[7] = "CREATE TABLE ".$phpwcms["db_prepend"]."_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=utf8;";

echo $sql[7]."<br />\n";

		
// setup inital ad formats
$sql_error = array();




// first create db tables
if(!_dbQuery($sql[0], 'DROP')) {

	
	//ignore errors
	//$sql_error[0] = '<p class="error">Error DROPPING <b>categories</b> initial database table: '.@htmlentities(@mysql_error(), ENT_QUOTES, PHPWCMS_CHARSET).'</p>';

}

if(!_dbQuery($sql[1], 'CREATE')) {

	$sql_error[1] = '<p class="error">Error creating <b>categories</b> initial database table: '.@htmlentities(@mysql_error(), ENT_QUOTES, PHPWCMS_CHARSET).'</p>';

}

if(!_dbQuery($sql[2], 'DROP')) {

	//ignore errors
	//$sql_error[2] = '<p class="error">Error DROPPING <b>shop_orders</b> initial database table: '.@htmlentities(@mysql_error(), ENT_QUOTES, PHPWCMS_CHARSET).'</p>';

}

if(!_dbQuery($sql[3], 'CREATE')) {

	$sql_error[3] = '<p class="error">Error creating <b>shop_orders</b> initial database table: '.@htmlentities(@mysql_error(), ENT_QUOTES, PHPWCMS_CHARSET).'</p>';

}

if(!_dbQuery($sql[4], 'DROP')) {

	//ignore errors
	//$sql_error[4] = '<p class="error">Error DROPPING <b>shop_products</b> initial database table: '.@htmlentities(@mysql_error(), ENT_QUOTES, PHPWCMS_CHARSET).'</p>';

}

if(!_dbQuery($sql[5], 'CREATE')) {

	$sql_error[5] = '<p class="error">Error creating <b>shop_products</b> initial database table: '.@htmlentities(@mysql_error(), ENT_QUOTES, PHPWCMS_CHARSET).'</p>';

}

if(!_dbQuery($sql[6], 'DROP')) {

	//ignore errors
	//$sql_error[6] = '<p class="error">Error DROPPING <b>sysvalue</b> initial database table: '.@htmlentities(@mysql_error(), ENT_QUOTES, PHPWCMS_CHARSET).'</p>';

}

if(!_dbQuery($sql[7], 'CREATE')) {

	$sql_error[7] = '<p class="error">Error creating <b>sysvalue</b> initial database table: '.@htmlentities(@mysql_error(), ENT_QUOTES, PHPWCMS_CHARSET).'</p>';

}



if(!count($sql_error)) {

	echo '<p>All inital db tables and values were created.</p>';
	echo "<p>Edit .../config/phpwcms/conf.inc.php change Code:<br /> \$phpwcms['SESSION_FEinit'] = 1; // set 1 to enable sessions in frontend, 0 to disable sessions in frontend<br /> Add:  \$phpwcms['Login_IPcheck'] = 0;</p>\n"; 
	echo '<p>Please delete folder <b>setup</b> which can be found inside the module folder here:</p>';
	
} else {

	echo implode(LF, $sql_error);

}


?>
Anyway, I had many of the same problems others had and the problem boiled down to getting the table names in the database to be consistent with the other table names. I can now save preferences and create catagories and products.

To incorporate this in the front end see the tutorial: ShopPHPWCMS.pdf file in the shop-module add-on for phpwcms 1.3.3 at:
http://web.casa-loca.com/index.php?shopmodule

my test site is working perfectly now.
All times are UTC+01:00
Page 1 of 2

Powered by phpBB® Forum Software © phpBB Limited