Additional Customers Fields

[ali.peracha]

Ok it is MYISAM. i just found it.... anything else i need to change in the sql statement?

#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 6

[ali.peracha]

Ok it is MYISAM. i just found it.... anything else i need to change in the sql statement?

#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 'DEFAULT CHARSET=latin1 AUTO_INCREMENT=1' at line 6

If i install the sql without the
ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

then i get this error on top of my admin page when i go to cusotmer add fields page

It would seem this feature cannot verify for any existent files, since the verification module could not be found. Perhaps you forgot to upload the function file that goes to extra_functions directory ?

[TheOracle]

Is there any way i can see which engine im using?

Absolutely. Under your PHPMyAdmin, you can see each types of each of your physical SQL fields inside each SQL tables. For instance, choose your regular customers table. Take a look at the type row, you should notice their types for each of them.

[TheOracle]

Perhaps you forgot to upload the function file that goes to extra_functions directory ?

Wonderful debug message I implemented isn't it ?

You did not uploaded your admin/includes/functions/extra_functions/additional_customers_fields.php file. Perhaps you forgot to do it while you were selecting the files right before the upload process ?

[TheOracle]

If i install the sql without the
ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

Never been a huge fan of Install SQL Patches. Use my last SQL query block I posted earlier today under your PHPMyAdmin - > SQL Query page.

Recall: Make sure your physical table does not exist first before attempting to create the table.

[ali.peracha]

Wonderful debug message I implemented isn't it ?

You did not uploaded your admin/includes/functions/extra_functions/additional_customers_fields.php file. Perhaps you forgot to do it while you were selecting the files right before the upload process ?

well that's what i thought too, but i tried it again and again.... (how stupid would i feel if i actually forgot to upload that file:)

i did install the new SQL block that you have in the last post, but i get the same thing. This time i'll delete all the files, delete the table and try it again... hopefully its gonna work...

i really want this to work coz i need company name, add, tele, wholesale tax info and other suff when a wholesale buyer registers.... so im kinnda desperate

i'll keep you posted, but if you do recall anything else that might be causing this prob do let me know.

thanks for your time man!

AP

[TheOracle]

What is your PHP and mySQL version ? To find out, go to your admin - > tools - > server info.

[ali.peracha]

What is your PHP and mySQL version ? To find out, go to your admin - > tools - > server info.

PHP Version 4.3.11
MySQL 4.0.27


well, the installation went well after i removed the myisam from the sql.

but now when i go to the customer page, i get this error and i don't see any new text fields i made in the additional_customer_field.php...

Warning: reset(): Passed variable is not an array or object in /home/content/g/e/o/georgidesign/html/store/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/content/g/e/o/georgidesign/html/store/admin/includes/classes/object_info.php on line 3

[TheOracle]

after i removed the myisam from the sql.

Then, the only possible conclusion is that your DB Type is not MyISAM (possibly InnoDB or simply ISAM).

Warning: reset(): Passed variable is not an array or object in /home/content/g/e/o/georgidesign/html/store/admin/includes/classes/object_info.php on line 29

Warning: Variable passed to each() is not an array or object in /home/content/g/e/o/georgidesign/html/store/admin/includes/classes/object_info.php on line 3

When exacly does this error occurs ?

[a_berezin]

Excuse that I interfere

CREATE TABLE customers_additional (
  field_id int(11) NOT NULL auto_increment,
  field_name varchar(255) NOT NULL default '',
  field_status char(2) NOT NULL default '',
  PRIMARY KEY (field_id)
) ENGINE=MyISAM;