Hello,
I'm trying to install wikindx4 in a wamp surrounding. I keep getting stopped at line 249 in ..SQL.php.
Like this:
( ! ) Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'wikindx'@'localhost' (using password: YES) in C:\wampserver2\www\wikindx4\wikindx4\core\sql\SQL.php on line 249
(...)
First I met this at Wampserver2 ver 2.2e,
then I tried the newest available Wamp5, but php was too low version.
So I tried wampserver 2.1.d, which made no difference.
So please, Mark or somebody-- which WAMP version is actually known to work properly with Wikidx4?
With hoes and regards,
Terje
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have come across problems with various versions of WAMP and wikindx but I do have WAMP running wikindx 4.1 on a windows machine at home. I'll have to check the version later today and will get back to you.
Mark was (of course) right - the privileges hadn't been set.
So now my DB has even been upgraded.
however, some new problems arose with parameters/arguments, so DB couldn't be opened.
Thus:
( ! ) Warning: mysqli_fetch_fields() expects parameter 1 to be mysqli_result, boolean given in C:\wampserver2\www\wikindx4\wikindx4\core\startup\UPDATEDATABASE.php on line 817
( ! ) Warning: Invalid argument supplied for foreach() in C:\wampserver2\www\wikindx4\wikindx4\core\startup\UPDATEDATABASE.php on line 818
( ! ) Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in C:\wampserver2\www\wikindx4\wikindx4\core\startup\UPDATEDATABASE.php on line 823
By the way - I'm running Windows 7 - Apache 2.2.17 - PHP 5.3.4 - MySQL 5.1.53
Regards
Terje
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Just to confirm, you are upgrading a v3.8.2 wikindx database? I understood from you first post that this was a fresh install.
Because you had some failures the first or other times you tried the update, did you start again from the beginning (i.e. drop your new database tables and reload the v3.8.2 database then start the upgrade again)?
The errors you point to are just warnings and that section (the final section of the upgrade) just performs a UTF-8 character check. As they were just warnings, I think you should have got to the end of the upgrade process. Is this right and you can now browse your wikindx? If so, if you download the repairkit plugin from SF, you can run the UTF-8 character check from there.
Regards,
Mark
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Mark,
thanks for your time!
Yes, I am upgrading. And I believe it is from 3.8.2. My old laptop
crashed entirely a year ago, so I'm not really quite sure. I'm importng
from a (structured) backup-file. According to phpMyAdmin it has 39 tables,
whereas after upgrade there are 46. First created empty wikndx4, gave
privileges, then imported, then ran wikindx4 program through 15 stages og
update. Stop occured during stage 15.
And database could not be read, according to this message:
Unable to read database.
SELECT * FROM WKX_wkx_bibtex_string
--> (Table 'wikindx4.wkx_wkx_bibtex_string' doesn't exist)
(There does exist a table named 'wkx_bibtex_string' - but none called
WKX_wkx_bibtex_string)
Just to confirm, you are upgrading a v3.8.2 wikindx database? I understood
from you first post that this was a fresh install.
Because you had some failures the first or other times you tried the
update, did you start again from the beginning (i.e. drop your new database
tables and reload the v3.8.2 database then start the upgrade again)?
The errors you point to are just warnings and that section (the final
section of the upgrade) just performs a UTF-8 character check. As they were
just warnings, I think you should have got to the end of the upgrade
process. Is this right and you can now browse your wikindx? If so, if you
download the repairkit plugin from SF, you can run the UTF-8 character
check from there.
That's the second time I've come across that bibtex_string issue but I've been unable to duplicate it. The best thing is to send the 3.8.2 dump to me and I can convert it. In fact, can you also send a v4.1 dump please so I can try to track down that error?
If you don't want to tell me your wikindx admin username/password:
Run the 3.8 database through wikindx 3.8.2 software and use Admin|Configure to change the admin username/password.
Dump the 3.8 database.
Upgrade that new 3.8 dump to v4.1 as far as you can then dump it.
Send both dumps to me with the new temporary admin username/password.
Hello,
I'm trying to install wikindx4 in a wamp surrounding. I keep getting stopped at line 249 in ..SQL.php.
Like this:
( ! ) Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'wikindx'@'localhost' (using password: YES) in C:\wampserver2\www\wikindx4\wikindx4\core\sql\SQL.php on line 249
(...)
First I met this at Wampserver2 ver 2.2e,
then I tried the newest available Wamp5, but php was too low version.
So I tried wampserver 2.1.d, which made no difference.
So please, Mark or somebody-- which WAMP version is actually known to work properly with Wikidx4?
With hoes and regards,
Terje
Hi Terje,
I have come across problems with various versions of WAMP and wikindx but I do have WAMP running wikindx 4.1 on a windows machine at home. I'll have to check the version later today and will get back to you.
You might also try XAMPP:
http://www.apachefriends.org/en/xampp-windows.html
which I use on my OSX computer for wikindx (but there is a windows version).
However, the error you get sounds like a problem accessing the SQL server which is probably not to do with PHP.
Regards,
Mark
Hi Terje,
XAMPP 1.7.4 works fine on my Windows 7 Machine:
ApacheFriends XAMPP (Basispaket) version 1.7.4
Thank You, Mark and toufexis.
Mark was (of course) right - the privileges hadn't been set.
So now my DB has even been upgraded.
however, some new problems arose with parameters/arguments, so DB couldn't be opened.
Thus:
( ! ) Warning: mysqli_fetch_fields() expects parameter 1 to be mysqli_result, boolean given in C:\wampserver2\www\wikindx4\wikindx4\core\startup\UPDATEDATABASE.php on line 817
( ! ) Warning: Invalid argument supplied for foreach() in C:\wampserver2\www\wikindx4\wikindx4\core\startup\UPDATEDATABASE.php on line 818
( ! ) Warning: mysqli_free_result() expects parameter 1 to be mysqli_result, boolean given in C:\wampserver2\www\wikindx4\wikindx4\core\startup\UPDATEDATABASE.php on line 823
By the way - I'm running Windows 7 - Apache 2.2.17 - PHP 5.3.4 - MySQL 5.1.53
Regards
Terje
Hi Terje,
Just to confirm, you are upgrading a v3.8.2 wikindx database? I understood from you first post that this was a fresh install.
Because you had some failures the first or other times you tried the update, did you start again from the beginning (i.e. drop your new database tables and reload the v3.8.2 database then start the upgrade again)?
The errors you point to are just warnings and that section (the final section of the upgrade) just performs a UTF-8 character check. As they were just warnings, I think you should have got to the end of the upgrade process. Is this right and you can now browse your wikindx? If so, if you download the repairkit plugin from SF, you can run the UTF-8 character check from there.
Regards,
Mark
Hi Mark,
thanks for your time!
Yes, I am upgrading. And I believe it is from 3.8.2. My old laptop
crashed entirely a year ago, so I'm not really quite sure. I'm importng
from a (structured) backup-file. According to phpMyAdmin it has 39 tables,
whereas after upgrade there are 46. First created empty wikndx4, gave
privileges, then imported, then ran wikindx4 program through 15 stages og
update. Stop occured during stage 15.
And database could not be read, according to this message:
Unable to read database.
SELECT * FROM
WKX_wkx_bibtex_string--> (Table 'wikindx4.wkx_wkx_bibtex_string' doesn't exist)
(There does exist a table named 'wkx_bibtex_string' - but none called
WKX_wkx_bibtex_string)
Regards,
Terje
2013/3/4 Mark Grimshaw sirfragalot@users.sf.net
Hi Terje,
That's the second time I've come across that bibtex_string issue but I've been unable to duplicate it. The best thing is to send the 3.8.2 dump to me and I can convert it. In fact, can you also send a v4.1 dump please so I can try to track down that error?
If you don't want to tell me your wikindx admin username/password:
My email can be found at the bottom here:
http://www.wikindx.com/gameaudio/wikindx4/index.php
Regards,
Mark