Sql error on signup script

I have a signup script on my websites that uses amember software. Until recently when users try to signup for my service, it gives a database error, similiar to this below.


Column count doesn't match value count at row 1

in query:

INSERT INTO amember_members (login,pass,e,name_f,name_l,street,city,state,zip,country,is_male,is_affiliate,aff_payout_type,unsubscribed,email_verified, added, remote_addr, data, aff_id ) VALUES ('test98', 'rivers', '', 'czc', 'zcxvc', '', '', '', '', '', '', '', '', '', '', NOW(), '', 'a:0:{}', '' )

But when you refresh webpage, it completes the transaction. The info is added to the database still, but it does not let you login with the password.

All old accounts are able to login.

This may be a simple project for a advance php programmer.

Urgently need fixing.

Evner: Perl, PHP

Se mere: sign script, webpage programmer, value city, sql programmer software, sql database programmer, software programmer service, programmer sql, php sql programmer, need a programmer urgently, mysql city state database, it service sql programmer, fixing websites, amember_members data column, t-sql with, t-sql in, on sql, error 0, Data e try, value added service, try on, t-sql;, street 3, sql software, sql script , sql project

Om arbejdsgiveren:
( 110 bedømmelser ) hayneville, United States

Projekt ID: #287425

Tildelt til:


I can research what is wrong and fix this issue. I need FTP access to your site.

$30 USD på 1 dag
(1285 bedømmelser)

5 freelancere byder i gennemsnit $30 på dette job


Hi, I can fix that in less than an hour. Please select me. Thank you,

$30 USD in 0 dage
(100 bedømmelser)

hey you ready to get the solution.

$30 USD på 1 dag
(15 bedømmelser)

I am ready to start right now, I should have ftp access to get it done

$30 USD in 0 dage
(0 bedømmelser)

I do it for you. Check PM

$30 USD in 0 dage
(0 bedømmelser)