« previous next »
Pages: [1]   Go Down

Author Topic: Error's in shown in PHP  (Read 1917 times)

Offline MHolkamp

  • User
  • *
  • Posts: 36
    • View Profile
Error's in shown in PHP
« on: August 10, 2010, 01:32:37 PM »
Hello,

Suddenly i see these error's :

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\knowledgeroot\include\class-mysql.php on line 113

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at C:\xampp\htdocs\knowledgeroot\include\class-mysql.php:113) in C:\xampp\htdocs\knowledgeroot\include\class-session.php on line 101

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\xampp\htdocs\knowledgeroot\include\class-mysql.php:113) in C:\xampp\htdocs\knowledgeroot\include\class-session.php on line 101

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\knowledgeroot\include\class-mysql.php on line 113

And after i login i see this:

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\knowledgeroot\include\class-mysql.php on line 113

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at C:\xampp\htdocs\knowledgeroot\include\class-mysql.php:113) in C:\xampp\htdocs\knowledgeroot\include\class-session.php on line 101

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\knowledgeroot\include\class-mysql.php on line 113

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\knowledgeroot\include\class-mysql.php on line 86

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\knowledgeroot\include\class-mysql.php on line 86

Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\knowledgeroot\include\class-mysql.php:113) in C:\xampp\htdocs\knowledgeroot\include\class-knowledgeroot-header.php on line 292

And nothing more.
Anyone any idea about this
Logged

Offline admin

  • Administrator
  • User
  • *****
  • Posts: 590
    • View Profile
    • http://www.lordlamer.de
Re: Error's in shown in PHP
« Reply #1 on: August 10, 2010, 03:01:05 PM »
Hi,

what version do you use?
Did you made an upgrade?
Is it a fresh installation?
What php,apache,mysql version are you using?

regards,
Frank
Logged

Offline MHolkamp

  • User
  • *
  • Posts: 36
    • View Profile
Re: Error's in shown in PHP
« Reply #2 on: August 10, 2010, 04:30:03 PM »
Hi,

I'm running 9.9.5.1 it is an upgrade from 9.9.1.
Apache/2.2.14 (Win32) DAV/2 mod_ssl/2.2.14 OpenSSL/0.9.8l mod_autoindex_color PHP/5.3.1 mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.10.1
MySql 5.1.41

regards
Martin
Logged

Offline admin

  • Administrator
  • User
  • *****
  • Posts: 590
    • View Profile
    • http://www.lordlamer.de
Re: Error's in shown in PHP
« Reply #3 on: August 10, 2010, 04:33:01 PM »
Logged

Offline MHolkamp

  • User
  • *
  • Posts: 36
    • View Profile
Re: Error's in shown in PHP
« Reply #4 on: August 10, 2010, 04:40:01 PM »
Hi,

Yes i did run the update.php script.

regards
Martin
Logged

Offline admin

  • Administrator
  • User
  • *****
  • Posts: 590
    • View Profile
    • http://www.lordlamer.de
Re: Error's in shown in PHP
« Reply #5 on: August 10, 2010, 08:13:16 PM »
Hi,

sounds a little bit like an update problem.
Could you create a dump of the structure in your database?
So i could check if a problem exists here.

regards,
Frank
Logged

Offline MHolkamp

  • User
  • *
  • Posts: 36
    • View Profile
Re: Error's in shown in PHP
« Reply #6 on: August 10, 2010, 08:21:16 PM »
Hi,

I just send it by e-mail

Regards
Martin
Logged

Offline MHolkamp

  • User
  • *
  • Posts: 36
    • View Profile
Re: Error's in shown in PHP
« Reply #7 on: August 11, 2010, 07:29:33 AM »
Mail Frank

--
Hi,

i have checked your dump!
You have some missing tables in your database.
These tables are: extensions, settings, users_login

The question now is why you have these missing tables. So you did a upgrade
from version 0.9.9.1 to 0.9.9.5. Did you made a upgrade to 0.9.9.1 from a
previous version or was the 0.9.9.1 a fresh install?

Did you have backups from your 0.9.9.1 installation?

regards,
Frank
---

Hi,

I do not have a backup of the old version (shame on me).
The 0.9.9.1 was already an upgrade from some 0.8 version.

Is it a possibility to fresh install 0.9.9.5.1 and restore the current dump over the new database?

regards
Martin
Logged

Offline admin

  • Administrator
  • User
  • *****
  • Posts: 590
    • View Profile
    • http://www.lordlamer.de
Re: Error's in shown in PHP
« Reply #8 on: August 11, 2010, 07:42:32 AM »
"Yes you can" ;)

Import the fresh mysql.sql so that you have the default structure and content.
After that you must check in what tables you have content. For this tables - empty the tables in the new database and import only the data to this tables.

This should work. If you have problems i could do it this evening for you.

regards,
Frank
Logged

Offline MHolkamp

  • User
  • *
  • Posts: 36
    • View Profile
Re: Error's in shown in PHP
« Reply #9 on: August 11, 2010, 09:07:57 AM »
Hi,

I managed to restore the most of the data.
I miss a few uploaded file, but i'm able to upload them again.

Thanks for your help.
My lesson for this time - Backup, backup backup

Regards
Martin
Logged

Offline admin

  • Administrator
  • User
  • *****
  • Posts: 590
    • View Profile
    • http://www.lordlamer.de
Re: Error's in shown in PHP
« Reply #10 on: August 11, 2010, 09:15:25 AM »
ok. Good to hear that it works.
If you have any trouble. Let me know.

Did you know the exact 0.9.8.x version that have you used before?

regards,
Frank
Logged

Offline MHolkamp

  • User
  • *
  • Posts: 36
    • View Profile
Re: Error's in shown in PHP
« Reply #11 on: August 11, 2010, 09:19:20 AM »
Hi,

I'm sorry.
I can not remember which version of 0.8 it was.

regards,
Martin
Logged
Pages: [1]   Go Up
« previous next »