Version 4 Errors

**Rusty007** · 07-26-2005

Hi Smoge & Friends,

I keep getting this error when new members sign up. Any reason for this ?

-----

Error in /lovebite/join_form.php: Duplicate entry '' for key 2
Query: 'INSERT INTO Profiles SET `ProfileType` = 'single', `NickName` = '', `RealName` = '', `Sex` = 'female', `Country` = 0, `City` = '', `zip` = '', `Children` = '0', `WhereChildren` = 'living with me', `WantChildren` = 'No', `DateOfBirth` = '1930-01-1--', `Height` = 0, `BodyType` = 0, `Ethnicity` = 0, `Religion` = 0, `MaritalStatus` = 0, `Occupation` = '', `Language1` = 0, `Language2` = 0, `Language3` = 0, `Education` = 0, `Income` = 0, `Smoker` = 0, `Drinker` = 0, `Headline` = '', `DescriptionMe` = '', `Email` = '', `EmailFlag` = 'HTML', `EmailNotify` = 'NotifyMe', `guestbook` = 'Enable', `HomePage` = '', `Phone` = '', `HomeAddress` = '', `IM` = 'none', `IcqUIN` = '', `Password` = '', `LookingFor` = 'female', `LookingAge` = '18-18-', `LookingHeight` = 0, `LookingBodyType` = 0, `Relationship` = 0, `DescriptionYou` = '', `LastReg` = NOW(), `seed` = 1097467104'

----

Also when a new cupid match was found the email received by the member looks like this...

----

<html><head></head><body style="font: 12px Verdana; color:#000000"> Hello <YourRealName>,

We are glad to inform you that profile was added or modified at LoveBite that match to you.

Match profile:<a>http://www.lovebite.org/lovebite/profile.php?ID=339</a>

Your Member ID:1

--
http://www.lovebite.org/lovebite/ (LoveBite)</body></html>

----

The next error since the upgrade is;

php: error while loading shared libraries: libmysqlclient.so.12: cannot open shared object file: No such file or directory

----

What am i missing here ??

Rusty

**Smoge** · 07-26-2005

Duplicate entry '' for key 2
Query: 'INSERT INTO Profiles SET `ProfileType` = 'single', `NickName` = '',

I'll try to help some.... Key 1 is the user ID. Key 2 is the NickName.

If you look at your SQL statement, as reported in the error, your NickName is blank.

Is NickName a required field on your system? If not, it should be.

Smoge

**Rusty007** · 07-27-2005

Originally Posted by Smoge

Duplicate entry '' for key 2
Query: 'INSERT INTO Profiles SET `ProfileType` = 'single', `NickName` = '',

I'll try to help some.... Key 1 is the user ID. Key 2 is the NickName.

If you look at your SQL statement, as reported in the error, your NickName is blank.

Is NickName a required field on your system? If not, it should be.

Smoge

Smoge Buddy,

Something is wrong on the new Version 4... Log in on my site as a new member, go straight to the end of the form without entering any data and press continue... See what happen...

Rusty

vivimos · 07-27-2005

Rusty,

Don't know what is happening on your site. There are a lot of bugs in 4.001 but I didn't find the problem you are experiencing.
One place I would look is to search for the language key relating to the "Ideal match description". Yours appears to be corrupted and is shown as:
Ideal match `desc`ription.

Perhaps you did this for a reason, but there isn't a matching key in the language file so I suspect not. Plus it isn't such a hot idea. The point is that it appears you picked up a couple of single quotation marks in that particular place and misplaced quotes can cause real havoc.

Depending on the number of modifications you have done. You might want to start with the original files for those that you find a misplaced single quote.

Just a suggestion.

**Rusty007** · 07-27-2005

Hi Rob,

That is just my point. I have replaced the language file as i have received it from aeWeb... No mods done... Still the same..

Will try to find the problem... btw i like your join php... for sale?

Keep well

Rusty

vivimos · 07-27-2005

Hi Rusty,

I didn't mean to indicate that the language file was the problem, but rather the program that called the language problem.

I looked a little further and found that the language key "_Ideal match description" is in the ProfilesDesc table in the database. It is in the 'namedisp' column of the 'DescriptionYou' row. So, check your ProfilesDesc table closely as it is not in agreement with the 4.001 download.

By the way the name is Carl. New to this forum.