[Done - Updated 2-21] YaPP to YSE 1.5.1

[David]

Can you please send me a dump of your tables after the conversion.  Or tell me the last table that has data in it.

[DJTommyC]

I've got the same error:

Code Select Expand

Duplicate entry '12-15-2002' for key 1
Can't login either and only have topics and no content..
The last table I have content in is 'yabbse_log_activity'.
Hope to get it fixed soon!
Grtz
Tommy

[David]

Ok, I think I know the problem.  The version of yabbse that YaPP uses did not check for duplicates in a table that now does not allow them.  I should get a patch for this out tonight or tommorrow.

[bg987]

Ok, I think I know the problem.  The version of yabbse that YaPP uses did not check for duplicates in a table that now does not allow them.  I should get a patch for this out tonight or tommorrow.

You rule man!

[David]

Try this

Find

Code Select Expand

mysql_query("INSERT INTO {$yse_prefix}log_activity (month, day, year, hits, topics, posts, registers, mostOn) VALUES ('$row[month]', '$row[day]', '$row[year]', '$row[hits]', '$row[topics]', '$row[posts]', '$row[registers]', '$row[mostOn]')") or die(mysql_error());

Change

Code Select Expand

INSERT

To

Code Select Expand

REPLACE

[bg987]

That worked great.  

Thank you very much David.

[DJTommyC]

It worked with me 2
Thx!

[David]

Ok, I will make a new zip with that change.

[Kitty]

getting this error:  Duplicate entry '0' for key 1  

http://www.chat-xpress.nl/prik/

got almost everything ....just only missing the members messages and the posts ....

Kitty

[David]

getting this error:  Duplicate entry '0' for key 1  

http://www.chat-xpress.nl/prik/

got almost everything ....just only missing the members messages and the posts ....

Kitty

Can you look in PHPMyAdmin and tell me the last table in the list that has data in it please.

[Kitty]

forum_log_online

is the last one

[David]

Try editing the convertor and add // before this line.

Code Select Expand

log_online_table($connection, $yapp_db, $yapp_prefix, $yse_db, $yse_prefix);

So that line now is

Code Select Expand

//log_online_table($connection, $yapp_db, $yapp_prefix, $yse_db, $yse_prefix);

[Kitty]

no suc6...

got now this error Duplicate entry 'agreement' for key 1

and this error on the forum
Warning: open_basedir restriction in effect. File is in wrong directory in /usr/local/psa/home/vhosts/chat-xpress.nl/httpdocs/prik/index.php on line 92

Warning: Failed opening 'dutch.lng' for inclusion (include_path='.:/usr/local/psa/apache/lib/php') in /usr/local/psa/home/vhosts/chat-xpress.nl/httpdocs/prik/index.php on line 92


and the last table in the PHP My Admin = forum_settings  

[David]

no suc6...

got now this error Duplicate entry 'agreement' for key 1

and this error on the forum
Warning: open_basedir restriction in effect. File is in wrong directory in /usr/local/psa/home/vhosts/chat-xpress.nl/httpdocs/prik/index.php on line 92

Warning: Failed opening 'dutch.lng' for inclusion (include_path='.:/usr/local/psa/apache/lib/php') in /usr/local/psa/home/vhosts/chat-xpress.nl/httpdocs/prik/index.php on line 92


and the last table in the PHP My Admin = forum_settings  

It seems in a few places you have duplicate data which has cuased both of these MySQL errors.  This should fix this one.

Change

Code Select Expand

mysql_query("INSERT INTO {$yse_prefix}settings (variable, value) VALUES ('$row[variable]', '$row[value]')") or die(mysql_error());

To

Code Select Expand

mysql_query("REPLACE INTO {$yse_prefix}settings (variable, value) VALUES ('$row[variable]', '$row[value]')") or die(mysql_error());

Let's get your data converted and then worry about the other errors.

[Kitty]

Your site is 100% YaPP free
Your old tables with YaPP have not been deleted incase for some reason you need them for backup or something.

Great ...The other error was a missing lng file ( dutch)

BUT  ....The forum banned me ? huh ??