Re: [phpslash-users] Problem upgrading from 0.62 to 0.65

[Joe S. <jo...@cm...>]

For anyone having trouble upgrading or installing phpslash due to 
problems with mysql, try this procedure posted to the sf.net patches:

[ 562394 ] Alt. table install and update for 0.65
https://sourceforge.net/tracker/index.php?func=detail&aid=562394&group_id=10566&atid=310566

slash-all-mysql-pre3.23.2.sql - This creates the db
without using the mysql md5 function.

6_to_65-mysql-pre3.23.2.sql - This updates the db to
0.65 except for the psl_author password field.

6_to_65.php3 - This script will update the psl_author
password field to 0.65. Copy to the basedir and run.
Remember to delete this file after use!

Thanks to Ajay and Costas for the db upgrade script I mangled to do this.

Please give feedback whether this works OK or not so we can update 
documentation and faqs.

Joe

On Thu, May 23, 2002 at 07:22:11PM -0700, J Hayward wrote:
> Hello,
> 
> I am trying to upgrade a website running 0.62. When I try to run the
> 6_to_65.sql script I am getting an error on this line:
> 
> UPDATE psl_author SET password = MD5(CONCAT(author_name,":",password));
> 
> The error displayed is:
> 
> ERROR 1064: You have an error in your SQL syntax near
> '(CONCAT(author_name,":",password))' at line 1
> 
> 
> Any ideas as to what the problem might be would be appreciated. Thanks.
> 
> Regards,
> 	Jim H
>