Can someone help

[Digerdoo]

1054 - Unknown column 'customers_username' in 'field list'

 

select customers_id, customers_username, customers_firstname, customers_password, customers_email_address, customers_default_address_id from customers where customers_username = ''

 

[TEP STOP]

[ArtRat]

1054 - Unknown column 'customers_username' in 'field list'

 

select customers_id, customers_username, customers_firstname, customers_password, customers_email_address, customers_default_address_id from customers where customers_username = ''

 

[TEP STOP]

<{POST_SNAPBACK}>

if you are reffering to the contribution that has USER NAME as a login,

look at the database stuff you pumped into mysql.

 

the entire package looks for "customer" but you just inserted "costumers"

as your field.

 

dictionary.com:

cus?tom?er

1, One that buys goods or services.

2, Informal. An individual with whom one must deal: a tough customer.

 

cos?tum?er

1, One that makes or supplies costumes, as for plays or masquerades.

2, A clothes tree.

 

fix you database.

[Digerdoo]

if you are reffering to the contribution that has USER NAME as a login,

look at the database stuff you pumped into mysql.

 

the entire package looks for "customer" but you just inserted "costumers"

as your field.

 

dictionary.com:

cus?tom?er  

1, One that buys goods or services.

2, Informal. An individual with whom one must deal: a tough customer.

 

cos?tum?er

1, One that makes or supplies costumes, as for plays or masquerades.

2, A clothes tree.

 

fix you database.

<{POST_SNAPBACK}>

 

So i create table customers_username ?

[ArtRat]

So i create table customers_username ?

<{POST_SNAPBACK}>

 

the table is already there

when you did the sql for this contrib you added it.

its just that the contributor didnt spell the word correctly.

 

phpmyadmin go to your database table and change the misplelled name to the correct spelling.

 

the sql that was included in this packeage:

 

ALTER TABLE `customers` ADD `costumers_username` VARCHAR( 32 ) NOT NULL AFTER `customers_id`;

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) 
VALUES (
'', 'Username', 'ENTRY_USERNAME_MIN_LENGTH', '3', 'Minimum lenght for the username field', '2', '17', NULL , '0000-00-00 00:00:00', NULL , NULL 
);

 

costumers is incorrect in the fact that nowhere in your php is 'costumer_username' queried. Change that OR everywhere in your php files change

the 'customers_username' instances to read 'costumers_username'

 

change the database is easier and the correct way:

ALTER TABLE `customers` ADD `customers_username` VARCHAR( 32 ) NOT NULL AFTER `customers_id`;

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) 
VALUES (
'', 'Username', 'ENTRY_USERNAME_MIN_LENGTH', '3', 'Minimum length for the username field', '2', '17', NULL , '0000-00-00 00:00:00', NULL , NULL 
);

better if you really look at all the code in this one and see if its correct before you add it to a live store.

note that the sql misspelled length too. 9no baddie but in admin it will be mispelled too.

 

also note that it will keep any "costumers" :D that you already have in your database from logining in.

 

you should create some code to allow:

username OR email address + password = valid login

if used on an existing store.

[Digerdoo]

the table is already there

when you did the sql for this contrib you added it.

its just that the contributor didnt spell the word correctly.

 

phpmyadmin go to your database table and change the misplelled name to the correct spelling.

 

the sql that was included in this packeage:

 

ALTER TABLE `customers` ADD `costumers_username` VARCHAR( 32 ) NOT NULL AFTER `customers_id`;

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) 
VALUES (
'', 'Username', 'ENTRY_USERNAME_MIN_LENGTH', '3', 'Minimum lenght for the username field', '2', '17', NULL , '0000-00-00 00:00:00', NULL , NULL 
);

 

costumers is incorrect in the fact that nowhere in your php is 'costumer_username' queried. Change that OR everywhere in your php files change

the 'customers_username' instances to read 'costumers_username'

 

change the database is easier and the correct way:

ALTER TABLE `customers` ADD `customers_username` VARCHAR( 32 ) NOT NULL AFTER `customers_id`;

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) 
VALUES (
'', 'Username', 'ENTRY_USERNAME_MIN_LENGTH', '3', 'Minimum length for the username field', '2', '17', NULL , '0000-00-00 00:00:00', NULL , NULL 
);

better if you really look at all the code in this one and see if its correct before you add it to a live store.

note that the sql misspelled length too. 9no baddie but in admin it will be mispelled too.

 

also note that it will keep any "costumers"  :D that you already have in your database from logining in.

 

you should create some code to allow:

username OR email address + password = valid login

if used on an existing store.

<{POST_SNAPBACK}>

----------------------------------------------------------

Now it works :thumbsup:

 

thanks to you very much!