v1.3.5 and shop module (beta)

Get help with installation and running official modules for phpwcms here. Please do not post bug reports or feature requests here.
User avatar
krailing
Posts: 119
Joined: Fri 20. Apr 2007, 11:17
Location: Schaffhausen/CH

Shop läuft nur zum Teil....

Post by krailing »

...habe Kategorien und Produkte, kann ein Produkt auswählen, wird in die Cart aufgenommen, und dann hat sichs. Kann weder zweites Produkt addieren, noch zum Checkout wandern, es heisst jedesmal «Cart is empty». Hab ich da einen Fehler beim DB-Update gemacht?

Noch eine Frage: wie wichtig ist die korrekte Collation? Wenn ich die Tables wie beschrieben erstelle, steht nachher zwar Latin1 drin, aber Latin1_Swedish1_ci und krieg das nicht anders rein.

Krake
jhofmann
Posts: 3
Joined: Tue 14. Aug 2007, 15:07
Location: LANGERWEHE (Germany)

Post by jhofmann »

Hi...

Hast du in der conf.inc.php

$phpwcms['SESSION_FEinit'] = 1;

??

Hat bei mir geholfen!

Gruß Jannik
User avatar
juergen
Moderator
Posts: 4556
Joined: Mon 10. Jan 2005, 18:10
Location: Weinheim
Contact:

Re: Shop läuft nur zum Teil....

Post by juergen »

krailing wrote: Noch eine Frage: wie wichtig ist die korrekte Collation? Wenn ich die Tables wie beschrieben erstelle, steht nachher zwar Latin1 drin, aber Latin1_Swedish1_ci und krieg das nicht anders rein.

Krake
Nein, das macht dir keine Probleme in deinem Sinne, es wird Sonderzeichen geben die falsch dargetsellt werden ...aber am Warenkorb ändert das nichts. Die Kollation kannst ja im sql File auch ändern. (text Editor)

Weiter vorne hatte flip-flop etwas von einem IP Eintrag erwähnt, in der config Datei, ich hatte das relativ früh nachgeholt, daher weiss ich nicht ob es das war was es nachher zum laufen brachte,
User avatar
krailing
Posts: 119
Joined: Fri 20. Apr 2007, 11:17
Location: Schaffhausen/CH

Post by krailing »

jhofmann wrote: Hast du in der conf.inc.php

$phpwcms['SESSION_FEinit'] = 1;
Genau das wars!

Dank & Gruss
Tom
User avatar
isac
Posts: 410
Joined: Tue 18. Nov 2003, 13:13
Location: Portugal
Contact:

Post by isac »

off topic :?

write in english for better understanding
POR :D TUGAL
Nordlicht
Posts: 160
Joined: Wed 12. Apr 2006, 08:16
Location: Germany, near Hamburg
Contact:

Post by Nordlicht »

Just tried the Shop-Modul of the 1.35 (20070919)
Can't add categories in the modul.
I get the following error:

Code: Select all

Warning: Invalid argument supplied for foreach() in ...\include\inc_module\mod_shop\inc\listing.categories.inc.php on line 214
Can someone with an already running shop help me?
User avatar
DeXXus
Posts: 2168
Joined: Fri 28. Nov 2003, 06:20
Location: USA - Florida

Post by DeXXus »

Nordlicht
Posts: 160
Joined: Wed 12. Apr 2006, 08:16
Location: Germany, near Hamburg
Contact:

Post by Nordlicht »

Already tried changing the URL in the
.../mod_shop/template/default/default.html

Still the same error.
User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Post by flip-flop »

DB updated after shop-setup? -> 20__1.3.5_to_1.3.5.1.sql
and in config
$phpwcms['Login_IPcheck'] = 0;
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
Nordlicht
Posts: 160
Joined: Wed 12. Apr 2006, 08:16
Location: Germany, near Hamburg
Contact:

Post by Nordlicht »

Great thanks.
fopulu
Posts: 359
Joined: Tue 2. May 2006, 14:19
Location: Rhein-Main

Post by fopulu »

Hat irgendwer, irgendwo schon mal eine Seite mit dem Shop-System am laufen und Erfahrung damit? Bestellabwicklung, Warenbestand, Produkte einpflegen, Angebotspreise, usw....!?

Ich will mich demnächst mal dransetzen und da würde mich interessieren, was alles so möglich ist und vor allem, wie einfach das ist.... :lol:
jscholtysik

Post by jscholtysik »

Hi fopulu,


this is the english section of phpwcms modules, so please try in the future to use this language instead of german language.


Joachim
User avatar
flip-flop
Moderator
Posts: 8178
Joined: Sat 21. May 2005, 21:25
Location: HAMM (Germany)
Contact:

Post by flip-flop »

@fopulu: It is beta version. Please read the tread from the beginning and you will see.

Knut
>> HowTo | DOCU | FAQ | TEMPLATES/DOCS << ( SITE )
nebenaube
Posts: 139
Joined: Fri 23. Nov 2007, 20:39
Location: Redlands, CA
Contact:

Re: v1.3.5 and shop module (beta)

Post by nebenaube »

nebenaube wrote: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.
larmann
Posts: 311
Joined: Thu 23. Jun 2005, 10:51
Location: Hamburg
Contact:

Price for using the Shop Module

Post by larmann »

Hi everybody,
where can I find the price / licence for using the shop module?
Thnak you
Post Reply