 |
 |
 |
 |
 |
| Author |
Message |
beef_yo
Joined: 25 Sep 2006
Posts: 9
Location: New Zealand |
|
 MySQL Installation issue |
 |
Hi Guys,
I am having issues installing CuteNews using a MySQL database.
I when I install CuteNews I get this error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in c:\Inetpub\wwwroot\life\upload3\inc\db\mysql.class.php on line 107
Which is this line in the table_exists function:
 | | for ($i = 0; $i < mysql_num_rows($list); $i++){ |
And when I add a line of debug code I get this additional information:
Unknown database 'life'
And funnily enough, the database has not been created.
If I manually create the database first, then install CuteNews, it creates the tables successfully, but no data is entered. Then of course when I go to log in my username/password comes back as incorrect, along with the error message:
Warning: Invalid argument supplied for foreach() in c:\Inetpub\wwwroot\life\upload3\inc\functions.inc.php on line 56
Which is this line in the check_login function:
| | foreach ($members as $row){ |
To me it seems the script is having real difficulties communicating with the MySQL database. I'm guessing it's something to do with my specific server, as it has had other MySQL difficulties in the past. I'm hoping however that someone has experienced a similar error, or worked with a similar set up and may know a solution.
Details of web server:
Windows Server 2003
IIS 6.0
PHP ver 5.1.6
MySQL 5.0.24a
[/code]
|
|
| Tue Oct 10, 2006 9:34 pm |
  |
|
Guest
|
| |
|
Please login to hide the ads.
|
|
|
|
|
ksen
Joined: 04 Jun 2006
Posts: 142
|
|
|
| Wed Oct 11, 2006 3:45 am |
|
|
beef_yo
Joined: 25 Sep 2006
Posts: 9
Location: New Zealand |
|
| |
|
Hi ksen,
Thanks for the reply.
I think I'll first try convincing my admin to downgrade to MySQL 4 - seeing as him and me are the only ones using it. Will hopefully save some effort on my part 
|
|
| Fri Oct 20, 2006 4:56 am |
|
|
ksen
Joined: 04 Jun 2006
Posts: 142
|
|
| |
|
Consider downgrading to php 4.x as well cos from what i'v read that seems to have some issues as well!! But i dont know it might work on ur's!! Give it a try 
|
|
| Fri Oct 20, 2006 12:58 pm |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
|
|
|
 |
 |
|
