Page 1 of 1

Error while counting user files

Posted: Tue 17. Aug 2010, 11:48
by sustia
Hi, when I try to open the file center I receive the error "error while counting user files", and if I try to upload a new file the error is "error while insert file information".

I asked to my administrator and he send me the errors he found:

Code: Select all

[17-Aug-2010 11:40:59] PHP Warning:  mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /raid0/web/cnr/guest/noria/docs/include/inc_lib/files.create.dirmenu.inc.php on line 32
[17-Aug-2010 11:40:59] PHP Warning:  mysql_free_result(): supplied argument is not a valid MySQL result resource in /raid0/web/cnr/guest/noria/docs/include/inc_lib/files.create.dirmenu.inc.php on line 39
The PHP Version is 4.3.8, and MySQL is: Client API version: 4.0.21


Any idea?

Re: Error while counting user files

Posted: Tue 17. Aug 2010, 18:47
by juergen
Hi ;)

did you check phpwcms_file table is not corrupted ?

Re: Error while counting user files

Posted: Tue 17. Aug 2010, 22:08
by sustia
DF6IH wrote:Hi ;)

did you check phpwcms_file table is not corrupted ?
Hi DF6IH, that's it, thanks for the hint!

I wrote to my administrator and now all works fine :D

Re: Error while counting user files

Posted: Tue 12. Oct 2010, 08:40
by culda_a
How can I solve this error? error while counting user files

what should i do to fix it?

thank you

Re: Error while counting user files

Posted: Tue 12. Oct 2010, 08:54
by update
How many files do you have there?

Re: Error while counting user files

Posted: Tue 12. Oct 2010, 08:55
by culda_a
I dont know how many files are ... when i try to upload pictures i see this message in Files section.

Re: Error while counting user files

Posted: Tue 12. Oct 2010, 13:35
by culda_a
In phpwcms_file I have the error below:

Code: Select all

Eroare
Comanda SQL: 

SHOW FULL FIELDS FROM  `phpwcms_file` ;


MySQL zice: 

#145 - Table './stephany_stephany/phpwcms_file' is marked as crashed and should be repaired 
How do i fix this?

Re: Error while counting user files

Posted: Tue 12. Oct 2010, 14:13
by culda_a
Well it seams that i had only to repair the database.