Thread: [phpslash-users] Problem upgrading from 0.62 to 0.65
Brought to you by:
joestewart,
nhruby
From: J H. <jim...@ea...> - 2002-05-24 02:20:35
|
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 |
From: Joe S. <jo...@cm...> - 2002-05-24 02:32:54
|
On Thu, May 23, 2002 at 07:22:11PM -0700, J Hayward wrote: > > Any ideas as to what the problem might be would be appreciated. Thanks. > What version of mysql? Is this from the command line or phpMyAdmin? |
From: J H. <jim...@ea...> - 2002-05-24 03:32:40
|
On Thu, 2002-05-23 at 19:31, Joe Stewart wrote: > On Thu, May 23, 2002 at 07:22:11PM -0700, J Hayward wrote: > > > > Any ideas as to what the problem might be would be appreciated. Thanks. > > > > What version of mysql? This is a friends website. His host seems to be behind the times. Now thats old. $ mysql -V mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) I am not that familiar with mysql, but I take it this is more then likely the problem? > > Is this from the command line or phpMyAdmin? From the command line. Thanks for the reply. Regards, Jim H P.S. Apologies I didn't realize the first reply went to your e-mail. |
From: Joe S. <jo...@cm...> - 2002-05-24 12:09:15
|
On Thu, May 23, 2002 at 08:34:18PM -0700, J Hayward wrote: > > $ mysql -V > mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) > I believe that was the version that md5 was introduced. Should be fine here. > I am not that familiar with mysql, but I take it this is more then > likely the problem? > > > > > Is this from the command line or phpMyAdmin? > > >From the command line. Thanks for the reply. > Probably the quickest way to get upgraded w/o code would be to add the 'god' account from slash-all.sql. or use this line: INSERT INTO psl_author VALUES (1,'god','','http://www.god.com','go...@he...', 'God doesn't need a 'quote'!','a87c20fb5245ed928efec7359c128b6e', 1000000,'root,nobody,user,topic,comment,story,storyeditor,section,submission,blo ck,poll,author,variable,glossary,mailinglist,logging'); Then login with god/password and modify,update each author. Then get rid of this account. Also if you didn't apply this line from 6_to_65.sql: INSERT INTO db_sequence (seq_name, nextid) VALUES ( 'psl_blocktype_seq ', '10'); hope this helps Joe > Regards, > Jim H > |
From: Joe S. <jo...@cm...> - 2002-05-24 12:46:05
|
On Fri, May 24, 2002 at 07:08:04AM -0500, Joe Stewart wrote: > > Then login with god/password and modify,update each author. Then get rid > of this account. > Sorry, not enough coffee - This will only work if you update the password in the form. |
From: J H. <jim...@ea...> - 2002-05-27 18:40:23
|
On Fri, 2002-05-24 at 05:08, Joe Stewart wrote: > On Thu, May 23, 2002 at 08:34:18PM -0700, J Hayward wrote: > > > > $ mysql -V > > mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) > > > > I believe that was the version that md5 was introduced. Should be fine > here. > Well I finally got back to checking this. From the changelog on the MySql website it looks like the MD5 function was introduced in 3.23.2 D.2.51 Changes in release 3.23.2 ....... # New functions EXPORT_SET() and MD5(). So the version his host is using is definitely older. > > > > Probably the quickest way to get upgraded w/o code would be to add the > 'god' account from slash-all.sql. > I actually tried that and it of course bombed out on the MD5 part. > or use this line: > > INSERT INTO psl_author VALUES > (1,'god','','http://www.god.com','go...@he...', > 'God doesn't need a > 'quote'!','a87c20fb5245ed928efec7359c128b6e', > 1000000,'root,nobody,user,topic,comment,story,storyeditor,section,submission,blo > ck,poll,author,variable,glossary,mailinglist,logging'); > I tried it no luck. Just dumps me back to the login page. > > hope this helps Thanks for the help. I think I will just try backing out the changes to the db and restore 0.62 for now. If you have a script that does that it would be nice. ;-) Regards, Jim H |
From: J H. <jim...@ea...> - 2002-05-28 19:53:13
|
On Tue, 2002-05-28 at 10:45, Joe Stewart wrote: > Hello, > > Finally getting back to this, sorry for the delay. No problem. I never expect replies on holiday's. ;-) > > The mysql md5 is only used to update the db. Otherwise it uses the php > function. OK. > > On Mon, May 27, 2002 at 11:42:26AM -0700, J Hayward wrote: > > > or use this line: > > > > > > INSERT INTO psl_author VALUES > > > (1,'god','','http://www.god.com','go...@he...', > > > 'God doesn't need a > > > 'quote'!','a87c20fb5245ed928efec7359c128b6e', > > > 1000000,'root,nobody,user,topic,comment,story,storyeditor,section,submission,blo > > > ck,poll,author,variable,glossary,mailinglist,logging'); > > > > > > > I tried it no luck. Just dumps me back to the login page. > > > > This should have worked. The username is now case-sensitive, so God will > not work. > > username: god > password: password Thats good to know, but unfortunately not the problem. I will check it again when I have time to see if I missed something else. > > > > I think I will just try backing out the changes to the db and restore > > 0.62 for now. If you have a script that does that it would be nice. ;-) > > > > I don't. The security model is much better in 0.65 as well as many other > bugfixes and enhancements. > I just restored 0.62 for now until I get more time. It was simple going back to 0.62 anyway. Yeah, I would like to get it upgraded, 0.65 looks like a nice update. > You might try dumping the db and putting it on another machine just to do > the db update and then move back. > > With mysqldump you can just dump that table only. > > If you're not able to do it on another machine, you can gzip the dump and > email it to me, I'll do it and email it back. > > A php script to do the update would be pretty simple also. Thanks, updating it on another machine won't be a problem if it comes to that. Thanks again for the help. Regards, Jim H |
From: Gurunandan R. B. <gu...@pl...> - 2002-05-29 06:49:16
|
Hi, Is it possible to disable comments per section or per topic? And while I have your attention, is it OK to set the title of a block to <img> for a block of type HTML? This works currently, but I wonder whether there is a better way to do this. Thank you. Regards, Gurunandan |
From: Joe S. <jo...@cm...> - 2002-05-30 15:15:17
|
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 > |
From: J H. <jim...@ea...> - 2002-05-31 14:45:13
|
On Thu, 2002-05-30 at 08:13, Joe Stewart wrote: > 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 > Thanks, Joe. I will try it as soon as I get a chance and let you know if it works. I will probably not get the chance before this weekend sometime. Regards, Jim H |
From: J H. <jim...@ea...> - 2002-06-03 00:57:03
|
On Thu, 2002-05-30 at 08:13, Joe Stewart wrote: > 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 Joe the php db update script worked great. :-) I have 0.65 up and running now. Now I just need to start editing the new templates. :P Thanks again. Regards, Jim H |