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: Comments won't display please help urgently  (Read 6006 times)

0 Members and 1 Guest are viewing this topic.

krupa

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Comments won't display please help urgently
« on: November 03, 2010, 02:47:03 pm »

ok my site now won't display comments and it keeps showing date error
i accidently dropped the comments table, thinking it will delete all comments but now i need to undo that. How do i get the comments table back, so my photo gallery can be viewed again?


http://simplysmritiirani.com/Gallery/


error message>

While executing query "SELECT count(*) FROM cpg14x_comments as c LEFT JOIN cpg14x_pictures as p ON c.pid=p.pid LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1" on 0

mySQL error: Table 'a3008425_cpg.cpg14x_comments' doesn't exist








please help

thanks
Logged

Nibbler

  • Guest
Re: Comments won't display please help urgently
« Reply #1 on: November 03, 2010, 02:55:50 pm »

Recreate it using phpMyAdmin.

Code: [Select]
CREATE TABLE cpg14x_comments (
  pid mediumint(10) NOT NULL default '0',
  msg_id mediumint(10) NOT NULL auto_increment,
  msg_author varchar(25) NOT NULL default '',
  msg_body text NOT NULL,
  msg_date datetime NOT NULL default '0000-00-00 00:00:00',
  msg_raw_ip tinytext,
  msg_hdr_ip tinytext,
  author_md5_id varchar(32) NOT NULL default '',
  author_id int(11) NOT NULL default '0',
  PRIMARY KEY  (msg_id),
  KEY com_pic_id (pid)
) TYPE=MyISAM COMMENT='Used to store comments made on pics';
Logged

krupa

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Comments won't display please help urgently
« Reply #2 on: November 03, 2010, 03:20:53 pm »

thanks alot for replying, im very new to php,
where do i go in phpmyadmin to recreate?

thanks heaps

Logged

krupa

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Comments won't display please help urgently
« Reply #3 on: November 03, 2010, 05:12:14 pm »

ok  i tried it but  i keep getting an error after creating it  :'(

i tried to write all the code in, its the first time.
please help
Logged

krupa

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Comments won't display please help urgently
« Reply #4 on: November 03, 2010, 07:44:34 pm »

update i recreated something

but still probs, i can't view any pictures

There was an error while processing a database query.

While executing query "SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip, pid FROM cpg14x_comments WHERE pid='483' ORDER BY msg_id ASC" on 0

mySQL error: Unknown column 'msg_author' in 'field list'
Logged

krupa

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Comments won't display please help urgently
« Reply #5 on: November 04, 2010, 02:08:30 am »

please please someone reply, i need to open the site without the gallery its not worth opening.
please help me get the gallery to work again  :'(
thanks
Logged

Joe Carver

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 1545
  • aka 'i-imagine'
    • Home Page
Re: Comments won't display please help urgently
« Reply #6 on: November 04, 2010, 03:01:13 am »

Please don't post without using common English capitalization and punctuation. This is an international forum

Run update.php.

Use phpmyadmin to check the condition of the table and db.

krupa

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Comments won't display please help urgently
« Reply #7 on: November 05, 2010, 03:04:37 pm »

hi thanks for replying.
Right  i ran the update, but its still running into an error.

This is what it said:
There was an error while processing a database query.
While executing query "SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip, pid FROM cpg14x_comments WHERE pid='431' ORDER BY msg_id ASC" on 0
mySQL error: Unknown column 'msg_author' in 'field list'  ???

any more advice would be helpful
thanks
Logged

krupa

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Comments won't display please help urgently
« Reply #8 on: November 05, 2010, 04:05:48 pm »

I am not really familar with how to create tables and everything, not sure exactly what i am doing, i don't really care if people can comment or not on the photos, but  i would like for them to able to view them in bigger size rather than just thumbnails. 
do i need to recreate the photo Gallery again from the start?
Logged

Nibbler

  • Guest
Re: Comments won't display please help urgently
« Reply #9 on: November 05, 2010, 05:28:28 pm »

Go into phpmyadmin, select your database, go to the "SQL" tab and copy/paste the code I gave you.
Logged

krupa

  • Coppermine newbie
  • Offline Offline
  • Posts: 8
Re: Comments won't display please help urgently
« Reply #10 on: November 05, 2010, 11:17:44 pm »

it worked thanks alot
i copied the code to  "SQL" tab and now the pictures are showing.
thanks again.
Logged
Pages: [1]   Go Up
 

Page created in 0.026 seconds with 19 queries.