Additional contact us fields

[TheOracle]

http://www.zen-cart.com/forum/showpo...33&postcount=2

[adam9110]

THanks for your kind mod.

But when i try to add a field from admin panel ..


I got the error

Unknown column 'customer_id' in 'field list'

What is the problems.

Thanks body.

[TheOracle]

Very vague description. Please provide more details on how this is happening.

- PHP Version.
- mySQL Version
- Zen-Cart Version.
- From which action this is happening ?
- Do you still have readings inside your TABLE_CUSTOMERS table (by looking into phpmyadmin) ?

[adam9110]

Very vague description. Please provide more details on how this is happening.

- PHP Version.
- mySQL Version
- Zen-Cart Version.
- From which action this is happening ?
- Do you still have readings inside your TABLE_CUSTOMERS table (by looking into phpmyadmin) ?

Thanks and my

PHP version is Version 5.1.2

Mysql is MySQL 5.0.18

Zen-Cart Version. is 1.3.5

after i fill the two fields and click the submit,

The error happens

1054 Unknown column 'customer_id' in 'field list'
in:
[INSERT INTO ec_contact_us_additional (field_id, customer_id, field_name, field_description, field_created_date, field_created_time, field_edit_date, field_edit_time, field_status) VALUES (NULL, '', 'dd', 'dd', '2007-06-11', '13:55:53', '', '', '1')]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I have deleted the exsited information in Table customers..
But it cannot solve the problem!!

[adam9110]

It is weird !

I have only "field_id, field_name, field_description, field_created_date, field_created_time, field_edit_date, field_edit_time, field_status" in my TABLE contact_us_additional..

But the error says

Unknown column 'customer_id' in the field list .......

what happens....

[adam9110]

In your

additional_contact_us.php

at arround 260 line

$sql_insert = "INSERT INTO " . TABLE_ADDITIONAL_CONTACT_US . " (field_id, customer_id, field_name, field_description, field_created_date, field_created_time, field_edit_date, field_edit_time, field_status) VALUES (NULL, '', '" . $contact_us_field_name . "', '" . $contact_us_field_description . "', '" . $date . "', '" . $time . "', '', '', '1')";

But where is the custome_ID field in Contact_us_additional table.......

After i remove the customer_id from the above sentence...
I got another error..

1136 Column count doesn't match value count at row 1

[adam9110]

ok ,Now i 've added the customer_id to the Table contact_us_additional artificially

After click the submit...

I got the error.

Warning: Cannot modify header information - headers already sent by (output started at D:\2spy\ecgadget\2spymanager\additional_contact_us.php:42) in D:\2spy\ecgadget\2spymanager\includes\functions\general.php on line 34

Has anyone succeeded in this mod??

[TheOracle]

Confirmed bugs. I have now refreshed the package from my site.

In the mean time, please do not post 5 topics in a row. If you're expecting more than a single issue with this MOD, post under a thread or two.

Empty (not just delete - but "empty") your additional contact us table and create new contact us fields again from the admin section.

[adam9110]

Hi Oracle,,

Did you updated ?

I still have interest to test it .

THanks.

[TheOracle]

Like I said on my previous post ... I updated the package on my site ...