Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Error when clicking on any filetype thumbnails  (Read 4571 times)

0 Members and 1 Guest are viewing this topic.

TRU

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Error when clicking on any filetype thumbnails
« on: July 06, 2006, 07:07:40 am »

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

« Last Edit: July 09, 2006, 09:15:16 am by Stramm »
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Error when clicking on any filetype thumbnails
« Reply #1 on: July 06, 2006, 07:19:26 am »

- enable debug on your gallery
- post a link to your gallery here
Logged
‍I don't answer to PM with support question
Please post your issue to related board

TRU

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Error when clicking on any filetype thumbnails
« Reply #2 on: July 06, 2006, 07:25:53 am »

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
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Error when clicking on any filetype thumbnails
« Reply #3 on: July 06, 2006, 07:29:57 am »

if you can't go to config then manualy enable it:
http://coppermine-gallery.net/tutorial/debug_mode.php
Logged
‍I don't answer to PM with support question
Please post your issue to related board

TRU

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Error when clicking on any filetype thumbnails
« Reply #4 on: July 06, 2006, 08:11:22 am »

ok debug is enabled.

Thanks for that link
Logged

Abbas Ali

  • Administrator
  • Coppermine addict
  • *****
  • Country: in
  • Offline Offline
  • Gender: Male
  • Posts: 2165
  • Spread the PHP Web
    • Ranium Systems
Re: Error when clicking on any filetype thumbnails
« Reply #5 on: July 06, 2006, 08:35:49 am »

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
Logged
Chief Geek at Ranium Systems

TRU

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Error when clicking on any filetype thumbnails
« Reply #6 on: July 06, 2006, 08:46:54 am »

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

TRU

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Error when clicking on any filetype thumbnails
« Reply #7 on: July 06, 2006, 08:55:27 am »

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
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Error when clicking on any filetype thumbnails
« Reply #8 on: July 06, 2006, 09:01:08 am »

- 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
Logged
‍I don't answer to PM with support question
Please post your issue to related board

TRU

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Error when clicking on any filetype thumbnails
« Reply #9 on: July 06, 2006, 11:42:30 am »

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.
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Error when clicking on any filetype thumbnails
« Reply #10 on: July 06, 2006, 11:52:58 am »

okey let try to recreate your table
open your coppermine database in PhpMyAdmin and execute this query
Code: [Select]
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;
Logged
‍I don't answer to PM with support question
Please post your issue to related board

TRU

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Error when clicking on any filetype thumbnails
« Reply #11 on: July 06, 2006, 12:27:13 pm »

Error
SQL query:

DROP TABLE IF EXISTS `cpg143_hit_stats` ;



MySQL said: 

#1051 - Unknown table 'cpg143_hit_stats'




thats what i got
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Error when clicking on any filetype thumbnails
« Reply #12 on: July 06, 2006, 12:36:28 pm »

okey try to repair that table by phpmyadmin
Logged
‍I don't answer to PM with support question
Please post your issue to related board

TRU

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Error when clicking on any filetype thumbnails
« Reply #13 on: July 07, 2006, 01:43:34 am »

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

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Error when clicking on any filetype thumbnails
« Reply #14 on: July 07, 2006, 08:23:22 am »

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.
Logged

TRU

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Error when clicking on any filetype thumbnails
« Reply #15 on: July 07, 2006, 11:30:17 am »


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.
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Error when clicking on any filetype thumbnails
« Reply #16 on: July 07, 2006, 11:33:30 am »

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.
Logged

TRU

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Error when clicking on any filetype thumbnails
« Reply #17 on: July 09, 2006, 06:58:16 am »

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
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Error when clicking on any filetype thumbnails
« Reply #18 on: July 09, 2006, 07:11:11 am »

You can find all table structure on {root of gallery}/sql/schema.sql
anyway this is for cpg143_favpics
Code: [Select]
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]
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;
Logged
‍I don't answer to PM with support question
Please post your issue to related board

TRU

  • Coppermine newbie
  • Offline Offline
  • Posts: 17
Re: Error when clicking on any filetype thumbnails
« Reply #19 on: July 09, 2006, 07:31:01 am »

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  ;D
Logged
Pages: [1]   Go Up
 

Page created in 0.024 seconds with 19 queries.