Purchase Ordering...

[apinkpony11]

Hi Guys,

I tried to get purchase ordering module working, but, it wont. The first step it says to upload dbscript.sql. My server comes back with the error:

1060 Duplicate column name 'po_sent'

The file looks like this:

DROP TABLE IF EXISTS `subcontractors`;

CREATE TABLE `subcontractors` (
  `subcontractors_id` int(10) unsigned NOT NULL auto_increment,
  `short_name` varchar(6) NOT NULL default '',
  `full_name` varchar(100) NOT NULL default '',
  `street1` varchar(100) NOT NULL default '',
  `city` varchar(255) NOT NULL default '',
  `state` varchar(255) NOT NULL default '',
  `zip` varchar(10) NOT NULL default '',
  `email_address` varchar(100) NOT NULL default '',
  `telephone` varchar(32) NOT NULL default '',
  `contact_person` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`subcontractors_id`)
) TYPE=MyISAM COMMENT='subcontractors' AUTO_INCREMENT=0;

ALTER TABLE `orders_products`
ADD `po_sent` char(1) NOT NULL default '0',
ADD `po_number` int(20),
ADD `po_sent_to_subcontractor` int(10),
ADD `po_date` DATE,
ADD `item_shipped` CHAR(1) NOT NULL default '0';

ALTER TABLE `products`
ADD `default_subcontractor` int(10) NOT NULL default '0';

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('PO - own stock', 'PO_OWN_STOCK_EMAIL', '[email protected]', 'The TO email for own stock Purchase Orders', 1, 101, now());
INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('PO - notify customer', 'PO_NOTIFY', '1', '0 - no customer notification of PO updates, 1 - notify customer', 1, 102, now());INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('PO - subject', 'PO_SUBJECT', 'PO #{po_number}', 'Subject of PO emails, {po_number} will be replaced with the actual number', 1, 103, now());

[apinkpony11]

bump, please

[rkeppert]

what modules do you have installed?

[apinkpony11]

um... super orders, easy populate, google adsense, google sitemaps, google analytics... the tracking one... i think thats all.

[rkeppert]

ok because the only module i know of that seems to cause problems is the tax exemption module... you might want to check your database... you are looking for zen_configuration and the structure should look like this:

configuration_title
configuration_key
configuration_value
configuration_description
configuration_group_id
sort_order
date_added

any other items inside zen_configuration will cause problems with any sql updates that you want to do... if you look and find something else, post here and i will try to help you modify the sql file to work with your database....

[n8pbm]

I just installed this mod and everything seems to run correctly except one thing. This mod sends an email to your distributor with details of the order. In that email their is a link that the distributor can click to enter tracking information. However if you click on the link I get a "Illegal Access" on the page.

The file is located in the admin directory so I think it might be a permission issue but I have no idea where to begin.

Using the latest version of Zen Cart with the Ty Tracking Mod installed.

Any ideas?

[apinkpony11]

ok because the only module i know of that seems to cause problems is the tax exemption module... you might want to check your database... you are looking for zen_configuration and the structure should look like this:

configuration_title
configuration_key
configuration_value
configuration_description
configuration_group_id
sort_order
date_added

any other items inside zen_configuration will cause problems with any sql updates that you want to do... if you look and find something else, post here and i will try to help you modify the sql file to work with your database....

I cant even find a file called zen_configuration, zen_configuration.php, used both CuteFTP and the search-gizmo on the admin to search for this file... nothing.

[Kim]

configuration_title
configuration_key
configuration_value
configuration_description
configuration_group_id
sort_order
date_added

You can't find them with FTP because they are not *files* they are database tables and are in your database.

[apinkpony11]

Wow... im silly. I should have known that.

[apinkpony11]

... Okay. Well, I've got all those fields, but I've also got...

last_modified
use_function
set_function