1054- Unknown Column in "field List

[Tamar2001]

I get the following error on our web-site when I try to confirm an order, for the end of the process:

 

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

 

insert into orders (customers_id, customers_name, customers_company, customers_street_address, customers_suburb, customers_city, customers_postcode, customers_state, customers_country, customers_telephone, customers_email_address, customers_address_format_id, delivery_name, delivery_company, delivery_street_address, delivery_suburb, delivery_city, delivery_postcode, delivery_state, delivery_country, delivery_address_format_id, billing_name, billing_company, billing_street_address, billing_suburb, billing_city, billing_postcode, billing_state, billing_country, billing_address_format_id, payment_method, cc_type, cc_owner, cc_number, cc_expires, date_purchased, orders_status, currency, currency_value, ipaddy, ipisp) values ('21', '***'', '', '***', '', '**', '***', '***', '***', '991111111111', '***', '1', '***', '', '***', '', '***, '***', '***', '***', '1', '**', '', '***', '', '***', '***', '***', '**', '1', 'Bank Transfer or Direct Deposit', '', '', '', '', now(), '1', 'GBP', '1.00000000', '***', '***')

 

[TEP STOP]

 

 

I have installed the IP recorder software, which records the customers IP address when they place an order.

 

I notice in the error message above that the address details are repeated three times.

 

 

The payment and order confirmation work for paypal, have checked this.

 

 

However, all the other payment options come up with same 1054 error message.

[Tamar2001]

I have just read further through the instructions on the Order_IP Recorder module and I missed out two modifications to the SQL as follows:

 

Alter Table 'orders' add 'ipaddy' VARCHAR(15) NOT NULL;

Alter Table 'orders' add 'ipisp' VARCHAR(15) NOT NULL;

 

Where do I find this information to run the SQL and makes these two changes so there is consistent logic please??

[♥Vger]

Access your website's database via phpMyAdmin - the link to phpMyAdmin may also be called MySQL Administration - in your web hosting control panel.

 

If the code you have is in a .sql file then use the Browse link to upload the file to the database.

 

If the code is not in its own .sql file but just copied into an Install file then copy and paste it into the SQL Query window in phpMyAdmin.

 

ALWAYS take a BACKUP of the db before doing any work with in in phpMyAdmin.

 

Vger

[Tamar2001]

Access your website's database via phpMyAdmin - the link to phpMyAdmin may also be called MySQL Administration - in your web hosting control panel.

 

If the code you have is in a .sql file then use the Browse link to upload the file to the database.

 

If the code is not in its own .sql file but just copied into an Install file then copy and paste it into the SQL Query window in phpMyAdmin.

 

ALWAYS take a BACKUP of the db before doing any work with in in phpMyAdmin.

 

Vger

 

Thank you for your very quick reply.

 

Have been checking our files which are situated on a remote server.

 

Am I correct in thinking the .cpanel stands for the control panel which I need to access?

 

Clicking on this brings up three subsidary files:

 

caches

datastore

nvdata

 

 

Also checked through the complete directory as follows hosted on the server and found a folder called php, but could not find phpMyAdmin.

 

What am I doing wrong??

 

Thank you for your time.

[Tamar2001]

I forgot to add that "sitlutions" host are site.

[♥Vger]

Forget about the cPanel folder you see in FTP. You need to go to your cPanel Web Hosting Control Panel and login with the User Name and Password your hosting company provided you with.

 

Once in there look for the phpMyAdmin link.

 

Vger

[Tamar2001]

VGER FIRSTLY A VER BIG THANK-YOU.

 

JUST BEEN LOOKING ON OUR WEB_SITE HOST AND QUICKLY FOUND LOTS OF OPTIONS I DIDN'T EVEN KNOW ABOUT, WOH, DELIGHTED.

 

FOUND AN IP Blocker which works if you have collected the IP addresses, so updated this.

 

 

Found the phpMyAdmin file, I need to add the following simple code but sure what to do with it:

 

 

Alter Table 'orders' add 'ipaddy' VARCHAR(15) NOT NULL;

Alter Table 'orders' add 'ipisp' VARCHAR(15) NOT NULL;

 

 

Thank you so much for your help and kindness to a newbie!

[♥Vger]

Click on the SQL link and paste this into the box that appears:

 

ALTER orders ADD ipaddy VARCHAR(15) NOT NULL;

ALTER orders ADD ipisp VARCHAR(15) NOT NULL;

 

Always take a backup of the db before working in phpMyAdmin!!

 

Vger

[Tamar2001]

Hi there again,

 

Just been looking around my website's database via phpMyAdmin.

 

This is what I see on the page:

 

 

Server version: 4.1.22-standard

Protocol version: 10

Server: Localhost via UNIX socket

User: judith69@localhost

MySQL charset: UTF-8 Unicode (utf8)

 

Create new database:

No Privileges

Show MySQL runtime information

Show MySQL system variables

Processes

Character Sets and Collations

Storage Engines

Databases

Export

Import

Log out

phpMyAdmin - 2.11.4

MySQL client version: 4.1.22

Used PHP extensions: mysql

Language : Afrikaans Shqip

Theme / Style: Darkblue/orangeDarkblue/orangeOriginal

Font size: 32%

phpMyAdmin documentation

phpMyAdmin wiki

Official phpMyAdmin Homepage

[ChangeLog] [subversion] [Lists]

 

 

There is no SQL browswer link to allow me to paste in these two lines?

 

AM I missing something obvious here??

 

Under my Data-Bases are the following:

 

MySQL@databases

 

 

MySQL@databasesWizard

 

phpMyAdmin

 

My Remote MySQL

 

Thank you for looking and your advice.

[BryceJr]

Follow this --> http://community.mybboard.net/showthread.php?tid=4720

[Tamar2001]

Follow this --> http://community.mybboard.net/showthread.php?tid=4720

 

Thank you for this posting, worked through this and now get a syntax error as follows in SQL:

 

Error

SQL query:

 

ALTER TABLE 'orders' ADD 'ipaddy'VARCHAR( 15 ) NOT NULL ;

 

 

 

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 ''orders' ADD 'ipaddy' VARCHAR(15) NOT NULL' at line 1

 

What am I doing wrong please??

 

Thank you

[Tamar2001]

The syntax error appears, due to my incorrect use of quotation marks:

 

If you use:

 

'orders' the file fails

 

If instead you use as follows, the file loads!

 

ALTER TABLE `orders` ADD `ipaddy` VARCHAR(15) NOT NULL;

ALTER TABLE `orders` ADD `ipisp` VARCHAR(15) NOT NULL;

 

THANK YOU FOR YOUR HELP!