Internal error

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Internal error

Postby marlon20 » 14. June 2009 12:24

Can anyone help with this error

Query Error reported on page /create_account.php
MySQL error: 1054 - Unknown column 'customers_fax' in 'field list'

insert into customers (customers_firstname, customers_lastname, customers_email_address, customers_telephone, customers_fax, customers_newsletter, customers_password) values ('Alan', 'Cee', 'note@arch-ways.com', '000000000000000', '', '1', '2e79a466fe053770991cd2a6ac9e4fd8:7d')



Many thanks Alan
marlon20
 
Posts: 3
Joined: 14. June 2009 10:05

Re: Internal error

Postby Wiedmann » 14. June 2009 15:00

Code: Select all
MySQL error: 1054 - Unknown column 'customers_fax' in 'field list'

You have no column 'customers_fax' in this table.
--> So you can't insert anything into this column.
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: Internal error

Postby marlon20 » 14. June 2009 15:37

Thanks for the reply,

I have only just started using databases, could you explain the fix.

Many Thanks Alan

P.S. Do you know where I can buy manuals.
marlon20
 
Posts: 3
Joined: 14. June 2009 10:05

Re: Internal error

Postby Wiedmann » 14. June 2009 16:53

could you explain the fix.

Add a column with this name to your table.

e.g. with phpMyAdmin:
- go to your database
- select your table
- open the "Structure" tab
- add the field.

BTW:
I have only just started using databases,

How can you write a SQL query, without knowing how to create/alter your dabase/table layout?
--> Is this your own script?

P.S. Do you know where I can buy manuals.

At Amazon?
BTW: MySQL and PHP have good online manuals.
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 143 guests