Delivery control

[Raghallaigh]

When I try to install the SQL Patch through ZenCart it comes back as failed, when I try to install the SQL Patch through PHPMyAdmin I get an error that says
Error

SQL query:

CREATE TABLE `delivery` ( `del_id` double NOT NULL AUTO_INCREMENT ,
`del_name` varchar( 60 ) default NULL ,
`del_date` date default '0000-00-00',
`del_status` tinyint( 1 ) default '0',
`del_delivered` date default '0000-00-00',
PRIMARY KEY ( `del_id` )
) CREATE TABLE `delivery_products` ( `del_id` double NOT NULL default '0',
`prod_id` double NOT NULL default '0',
`prod_quantity` double default '0'
)
MySQL said:
#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 'CREATE TABLE `delivery_products` (
`del_id` double NOT NULL default '0',
`' at line 10

I got this message when I tried to install the module today as well, sadly I lack any coding experience other then edits I am told to make - would anyone care to try and help a noob out? at present the only other mods i have installed are super orders and google analytics.

Thanks,

Oisín

[shrek99]

I got this message when I tried to install the module today as well, sadly I lack any coding experience other then edits I am told to make - would anyone care to try and help a noob out? at present the only other mods i have installed are super orders and google analytics.

Thanks,

Oisín

You have forgotten " ; " in the end

CREATE TABLE `delivery` ( `del_id` double NOT NULL AUTO_INCREMENT ,
`del_name` varchar( 60 ) default NULL ,
`del_date` date default '0000-00-00',
`del_status` tinyint( 1 ) default '0',
`del_delivered` date default '0000-00-00',
PRIMARY KEY ( `del_id` )
) CREATE TABLE `delivery_products` ( `del_id` double NOT NULL default '0',
`prod_id` double NOT NULL default '0',
`prod_quantity` double default '0'
);


If that does not work try to remove " ` "

CREATE TABLE delivery (del_id double NOT NULL AUTO_INCREMENT ,
del_name varchar(60) default NULL ,
del_date date default '0000-00-00',
del_status tinyint(1) default '0',
del_delivered date default '0000-00-00',
PRIMARY KEY (del_id)
) CREATE TABLE delivery_products (del_id double NOT NULL default '0',
prod_id double NOT NULL default '0',
prod_quantity double default '0'
);

[pockets]

Hi

I am late to this thread, so I hope you are still reading it.

I have installed the Delivery Control, created the database tables and manually inserted 1 test record into each.

I can see the delivery table and view the details of the one "purchase order", but none of the buttons for New Delivery or Add Product are working. They display the PHP page name they should go to, but nothing happens.

What could I have done wrong?

Thanks.

[thebeadyeye]

I've installed the new version of this module. It works except that when the delivery is received it writes double the amount of stock into each item. Any suggestions?

[nikki72]

I just installed this on the lastest zen version.

I get this error when going to delivery.php.

1146 Table 'antiocho_zc1.products' doesn't exist
in:
[SELECT d.prod_id AS id, d.prod_quantity AS quantity, p.products_model AS model, pd.products_name AS name FROM delivery_products d LEFT JOIN products p ON d.prod_id = p.products_id LEFT JOIN products_description pd ON d.prod_id = pd.products_id WHERE d.del_id = '']

Any help?? TY

[Tim Ware]

I've installed the new version of this module. It works except that when the delivery is received it writes double the amount of stock into each item. Any suggestions?

I have this same exact issue on zencart 1.3.7.1 and latest mod version.

Everything else seems to be working fine.. Apart from a minor glitch with the popup calendar but it's not much of an issue..

Would really like to be able to use this mod on a live site, and it seems almost ready apart from adding double the amount of stock.

Please help..

[Tim Ware]

After a little more testing with this mod...

I have noticed that if I do a page refresh (f5) on the delivered page prior to clicking the (mark as delivered) button the stock quantity is added correctly.

However as stated before if I don't do a page refresh in the delivery section it adds double the quantity to the products..

Is there a way of making it do some kinda page refresh automatically before I hit the (mark as delivered) button. So it adds the right quantity?

BTW it also subtracts double the quantity, unless I do a page refresh in the same manor..

Hope this makes sense...

[chemvil]

hi
ZC version. 1.3.8
delivery control version the latest

hope the forum is still active,
i tried to install the delivery control
i created the database manually
and then i get error like this

1146 Table 'shop.products' doesn't exist
in:
[SELECT d.prod_id AS id, d.prod_quantity AS quantity, p.products_model AS model, pd.products_name AS name FROM delivery_products d LEFT JOIN products p ON d.prod_id = p.products_id LEFT JOIN products_description pd ON d.prod_id = pd.products_id WHERE d.del_id = '']

i tried to edit the delivery.php and delivered.php
from

LEFT JOIN products p
ON d.prod_id = p.products_id

LEFT JOIN products_description pd
ON d.prod_id = pd.products_id

to

LEFT JOIN zc_products p
ON d.prod_id = p.products_id

LEFT JOIN zc_products_description pd
ON d.prod_id = pd.products_id

because my ZC database is using zc_ as prefix

after that i can add new delivery, but i noticed there are some errors

- got some problem with date selector, cannot choose the date corretly
- i cannot add new product., after i added, it goes back to admin home page, no confirmation, anything i should do?

anyone can help me?

many thanks
all helps are appreciated coz i kind of need this mod

[crazycucumber]

I have got to the same stage as you - is the original author still developing this mod or has he laid it to rest .

I get the blank page after adding product too.
and the date selector only works if you manually enter the month in .

Anyone working with this OK ?