phpwcms Support Forum

Hi, I have installed the Company mod, but I have a problem.
When I try to insert a new product base information i read this error:

Error in Query: INSERT INTO phpwcms_products SET product_name = 'Angelo', category = 'Libri', image_info = '', 'description = '', contact_name = 'angelo', system_req = ''

I have modified all the files and I have create all the tables, so I don't understan why I receive this error

The version of phpwcms is 1.1-RC2 // release date: 2004-04-04

I am not at home at the moment and with friends, so I don't have enough time to look deeper in the code and search the problem. I will do this tomorrow (sunday) night, when I am back.

Thank you for your patience (that I hope you have

)

Thanks Jérôme, I'm sure that your patience is greater than mine

sustia wrote:Thanks Jérôme, I'm sure that your patience is greater than mine

Try to delete the tables again:

then run this command:

Code: Select all

CREATE TABLE `phpwcms_products` (
  `prod_id` int(11) NOT NULL auto_increment,
  `category` varchar(50) NOT NULL default '',
  `product_name` varchar(50) NOT NULL default '',
  `system_req` text,
  `contact_name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`prod_id`)
) TYPE=MyISAM;

CREATE TABLE `phpwcms_products_prices` (
  `pr_id` int(11) NOT NULL auto_increment,
  `prod_id` int(11) NOT NULL default '0',
  `description` varchar(200) NOT NULL default '',
  `value` blob,
  `display_pos` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pr_id`)
) TYPE=MyISAM;

CREATE TABLE `phpwcms_mod_company` (
  `conf_option` text NOT NULL,
  `value` text NOT NULL
) TYPE=MyISAM;

CREATE TABLE `phpwcms_products_releases` (
  `r_id` int(11) NOT NULL auto_increment,
  `prod_id` int(11) NOT NULL default '0',
  `release` varchar(10) NOT NULL default '',
  `date` date default NULL,
  `description` text,
  PRIMARY KEY  (`r_id`)
) TYPE=MyISAM;

and after that, then run this:

Code: Select all

INSERT INTO `phpwcms_mod_company` VALUES ('currency_symbol', '£ ');
INSERT INTO `phpwcms_mod_company` VALUES ('additional_priceinfo', 'Additional price info');
INSERT INTO `phpwcms_mod_company` VALUES ('pricelist_head', 'Price list for the product');
INSERT INTO `phpwcms_mod_company` VALUES ('releaselist_head', 'Releases of the product');

first and foremost happy easter everyone
i made everything as written to install the company mod and got this funky funky result

what can that be?

...think i got the mistake...

yes, 'twas a stupid one...

frold wrote: Try to delete the tables again:

then run this command:

Hi guys, first of all happy easter

frold, I've done what you say, but the result when I try to insert somethig is:

Code: Select all

Error in Query: INSERT INTO phpwcms_products SET product_name = 'dsf', category = '', image_info = '', 'description = 'dfs', contact_name = 'fds', system_req = 'dsf'

Really I don't understand why

I try another time to install this mod, bun it doesn't woks...

Nobody can help me?

i have worked on the GT-MOD until now, but during the wait for bug-reports of this one, I will now look at this problem... Stay tuned...

I don't know why, but you have an apostroph too much in your query:

Code: Select all

'description = ''

Normally, everybody should have this problem and not only you - that's strange. Are you sure you have downloaded the latest release?

Look here... just when i wrote the post above, snobba posted somewhere else. So it is obviously my error. I will fix it and post a bugfix release!

You can download the new bugfix-release here.

Ok, Jérôme, thanks a lot.

When something doesn't works I always think that I'm wrong

No, you can always think that it is an error in the MOD, that is it in the most cases (except of the graphical text MOD

)

phpwcms Support Forum

Problem with the Company mod

Problem with the Company mod