Error when clicking on any filetype thumbnails

[TRU]

This error started coming up all of a sudden when i click on a thumbnail to enlarge the pic, or click a video to watch:

There was an error while processing a database query

how can i go about fixing this?  :-/

Thankx for the help

TRU

[Sami]

- enable debug on your gallery
- post a link to your gallery here

[TRU]

well i wont be able to do that since im getting the same error when i try to log on.

heres the link anyway

http://tru.servemp3.com/cpg/index.php

adult content on there too, dont say i didnt warn yall lol

[Sami]

if you can't go to config then manualy enable it:
http://coppermine-gallery.net/tutorial/debug_mode.php

[TRU]

ok debug is enabled.

Thanks for that link

[Abbas Ali]

The table 'cpg143_hit_stats' is missing from the db. Did you deleted it by any chance?

Also update to the latest stable version i.e. cpg1.4.8

[TRU]

naw i didnt delete it. matter of fact i see it listed as 1 of the tables in the database

[TRU]

Error
SQL query: 

SHOW INDEX FROM `cpg143_hit_stats` ;



MySQL said: 

#1146 - Table 'coppermine.cpg143_hit_stats' doesn't exist



but i see it in the list

[Sami]

- first you need to Upgrade
http://coppermine-gallery.net/demo/cpg14x/docs/index.htm#14
- after upgrade if you still have problem we can check

[TRU]

ok i upgraded and the problem is still there, only thing is its a different file now thats missing from the database, but i see it in the list.

[Sami]

okey let try to recreate your table
open your coppermine database in PhpMyAdmin and execute this query

Code Select Expand


DROP TABLE IF EXISTS `cpg143_hit_stats`;
CREATE TABLE  `cpg143_hit_stats` (
  `sid` int(11) NOT NULL auto_increment,
  `pid` varchar(100) NOT NULL default '',
  `ip` varchar(20) NOT NULL default '',
  `search_phrase` varchar(255) NOT NULL default '',
  `sdate` bigint(20) NOT NULL default '0',
  `referer` text NOT NULL,
  `browser` varchar(255) NOT NULL default '',
  `os` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`sid`)
) type=MyISAM;


[TRU]

Error
SQL query:

DROP TABLE IF EXISTS `cpg143_hit_stats` ;



MySQL said: 

#1051 - Unknown table 'cpg143_hit_stats'




thats what i got

[Sami]

okey try to repair that table by phpmyadmin

[TRU]

no luck, it wont let me do anything with that table. looks like i to have to uninstall coppermine completely and install it again

[Joachim Müller]

Ask your webhost for support. Before you install from scratch, create a backup both of your files and your mySQL database tables (except the broken table). Then create a fresh install and restore your files and the mySQL dump.

[TRU]

lol im the webhost. Im using the latest version of Abyss Webserver, which is running from the computer im on now.

But im going to backup my tables except the broken ones like you said and see if that works. because theres more than 1 table thats giving me the "doesn't exist" error.

[Joachim Müller]

That's one of the reasons why we don't recommend self-hosting. You should only consider self-hosting if you really, absolutely know your way around in webserver setup. Please don't get me wrong, I'm not trying to be rude, but imo you don't appear to have the skills needed to run a webserver of your own.

[TRU]

Yea im getting there, i only started doing my own hosting to host my own music for my webpage, somethin simple.

i got 3 tables deleted that were bad.

Table  'cpg143_hit_stats'  was recreated correctly using the code you gave me, now i need  the code for tables

'cpg143_favpics'
'cpg143_vote_stats'

after that i'll do a complete database backup if it works.

Thanks

[Sami]

You can find all table structure on {root of gallery}/sql/schema.sql
anyway this is for cpg143_favpics

Code Select Expand


DROP TABLE IF EXISTS `cpg143_favpics`;
CREATE TABLE  `cpg143_favpics` (
  `user_id` int(11) NOT NULL default '0',
  `user_favpics` text NOT NULL,
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM COMMENT='Stores the server side favourites';

and this is for cpg143_vote_stats

Code Select Expand


DROP TABLE IF EXISTS `cpg143_vote_stats`;
CREATE TABLE  `cpg143_vote_stats` (
  `sid` int(11) NOT NULL auto_increment,
  `pid` varchar(100) NOT NULL default '',
  `rating` smallint(6) NOT NULL default '0',
  `ip` varchar(20) NOT NULL default '',
  `sdate` bigint(20) NOT NULL default '0',
  `referer` text NOT NULL,
  `browser` varchar(255) NOT NULL default '',
  `os` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`sid`)
) TYPE=MyISAM;


[TRU]

I inserted the codes you gave me and the coppermine site is workin correctly. I did the database backup as well.

Thanks for all the great help guys