What does this mean this error ?

Building Top Rated ...
Done (0.78 s)

Skipping Detailed Build (disabled).

Building Category pages ...

Building category Aerospaziale e Militare ...
Links: 14
A fatal error has occured:Can't call method "fetchall_hashref" on an undefined value at Links::Build::build_category line 87.
Please enable debugging in setup for more details.
Stack Trace
======================================
Links (28877): Links::environment called at /home/mysite/public_html/cgi-bin/admin/Links.pm line 431 with no arguments.
Links (28877): Links::fatal called at Links::Build::build_category line 87 with arguments
(Can't call method "fetchall_hashref" on an undefined value at Links::Build::build_category line 87.
).
Links (28877): Links::Build::build_category called at /home/mysite/public_html/cgi-bin/admin/GT/Plugins.pm line 108 with arguments
(HASH(0x8921608)).
Links (28877): GT::Plugins::dispatch called at /home/mysite/public_html/cgi-bin/admin/Links/Build.pm line 30 with arguments
(GT::Plugins, /home/mysite/public_html/cgi-bin/admin/Plugins, build_category, *Links::Build::build_category, HASH(0x8921608)).
Links (28877): Links::Build::build called at nph-build.cgi line 587 with arguments
(category, HASH(0x8921608)).
Links (28877): main::_build_category called at /home/mysite/public_html/cgi-bin/admin/GT/Plugins.pm line 108 with arguments
(GT::SQL::Condition=HASH(0x873c2a4)).
Links (28877): GT::Plugins::dispatch called at nph-build.cgi line 135 with arguments
(GT::Plugins, /home/mysite/public_html/cgi-bin/admin/Plugins, create_category_changed, CODE(0x825d114), GT::SQL::Condition=HASH(0x873c2a4)).
Links (28877): main::build_changed called at nph-build.cgi line 39 with no arguments.
Links (28877): main::main called at nph-build.cgi line 30 with no arguments.


System Information
======================================
Perl Version: 5.008
Links SQL Version: 2.1.2
DBI.pm Version: 1.42
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = Failed to execute query: '
SELECT inm_Links.*
FROM inm_CatLinks, inm_Links
WHERE inm_CatLinks.LinkID = inm_Links.ID AND (inm_Links.isValidated = 'Yes' AND inm_CatLinks.CategoryID = '51421')
ORDER BY Top_Order DESC, isNew DESC,isPopular DESC,Title LIMIT 0, 10
' Reason: Got error 28 from table handler
@INC =
/home/mysite/public_html/cgi-bin/adcycle

---

Thanks in Advance
Bye From Italy

If you've done anything to your database or site recently, you might want to "repair tables."

What happens with this sort of error, is something returned a 'null' or 'empty' value for an SQL query where it was expected to get a value back of some sort.

This happens a *lot* for different reasons.

Installing a plugin, changing a global, changing the database password, etc can all do this.

First step is to repair your table, fix up the information. If that doesn't work, enable debugging, and see where/what query is failing.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

I haven't installed any plugin or other on my site, so I've repaired the tables but it's the same, the debugging has already enabled such U can see at the prev post

---

Thanks in Advance
Bye From Italy

Check your logs.
See where the SQL query fails. That points you to the reason.
*something* changed for this to happen.
Until you know why/where it's virtually impossible to track down.
Your logs might hold the answer, though.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

Error code 28: No space left on device

ok, I've checked on the site error_logs,
this is the output:

SELECT COUNT(*)
FROM site_CatLinks, site_Links
WHERE site_CatLinks.LinkID = site_Links.ID AND (site_Links.isValidated = 'Yes' AND site_CatLinks.CategoryID = '51421')

from main::_build_category at nph-build.cgi line 576
GT::SQL::Driver::MYSQL::sth (9854): Query execution took: 0.000293s from main::_build_category at nph-build.cgi line 576
GT::SQL::Driver::MYSQL::sth (9854): Executing query: SELECT * FROM site_Category WHERE ( ID = 51421 ) from Links::Build::build_category at Links::Build::b$
GT::SQL::Driver::MYSQL::sth (9854): Query execution took: 0.000341s from Links::Build::build_category at Links::Build::build_category line 21
GT::SQL::Driver::MYSQL::sth (9854): Executing query: SELECT Category_Template FROM site_Category WHERE ID = 51421 from Links::Category::template_set at /h$
GT::SQL::Driver::MYSQL::sth (9854): Query execution took: 0.000287s from Links::Category::template_set at /home/mysite/public_html/cgi-bin/admin/Links/Cat$
GT::SQL::Driver::MYSQL::sth (9854): Executing query: SELECT FatherID,ID FROM site_Category WHERE ID = 51421 from Links::Category::_parents at /home/inmrom$
GT::SQL::Driver::MYSQL::sth (9854): Query execution took: 0.000264s from Links::Category::_parents at /home/mysite/public_html/cgi-bin/admin/Links/Categor$
GT::SQL::Driver::MYSQL::sth (9854): Executing query:
SELECT site_Links.*
FROM site_CatLinks, site_Links
WHERE site_CatLinks.LinkID = site_Links.ID AND (site_Links.isValidated = 'Yes' AND site_CatLinks.CategoryID = '51421')
ORDER BY Top_Order DESC, isNew DESC,isPopular DESC,Title LIMIT 0, 10
from Links::Build::build_category at Links::Build::build_category line 82
GT::SQL::Relation (9854): Failed to execute query: '
SELECT site_Links.*
FROM site_CatLinks, site_Links
WHERE site_CatLinks.LinkID = site_Links.ID AND (site_Links.isValidated = 'Yes' AND site_CatLinks.CategoryID = '51421')
ORDER BY Top_Order DESC, isNew DESC,isPopular DESC,Title LIMIT 0, 10
' Reason: Got error 28 from table handler at /home/mysite/public_html/cgi-bin/admin/GT/SQL/Driver/MYSQL.pm line 117.
Can't call method "fetchall_hashref" on an undefined value at Links::Build::build_category line 87.

---

Thanks in Advance
Bye From Italy

Erm, Laura has already told you your problem

You have no space in your MySQL database left. You either need to clean some of the database out (i.e 'ClickTrack' or something), or get the amount of space that you can use upgraded.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Isn't like Laura sayd, becouse my site goes on dedcated server so it have unlimited mysql and web space

---

Thanks in Advance
Bye From Italy

In SSH, type;

df -H

... what does that show you?

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Filesystem Size Used Avail Use% Mounted on
/dev/hda3 57GB 7.9GB 47GB 15% /
/dev/hda1 104MB 20MB 79MB 20% /boot
none 524MB 0 524MB 0% /dev/shm
/usr/tmpDSK 100MB 100MB 0 100% /tmp
/tmp 254MB 254MB 0 100% /var/tmp
/dev/tmpMnt 100MB 100MB 0 100% /tmp

---

Thanks in Advance
Bye From Italy

Filesystem Size Used Avail Use% Mounted on
/dev/hda3 57GB 7.9GB 47GB 15% /
/dev/hda1 104MB 20MB 79MB 20% /boot
none 524MB 0 524MB 0% /dev/shm
/usr/tmpDSK 100MB 100MB 0 100% /tmp
/tmp 254MB 254MB 0 100% /var/tmp
/dev/tmpMnt 100MB 100MB 0 100% /tmp

See the parts in red... note that they are 100% full.. which is where your problem most likely lies.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

so I can delete all on these directory ??? are temporaney directory ??

---

Thanks in Advance
Bye From Italy

You would need to talk to your server admin. I wouldn't want to comment, in case you delete something you shouldn't :p

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Ok I've just asked to DC, thanks

---

Thanks in Advance
Bye From Italy