coppermine-gallery.com/forum

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

Recreate it using phpMyAdmin.


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';


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

thanks heaps

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

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'

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

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.

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

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?

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

it worked thanks alot
i copied the code to  "SQL" tab and now the pictures are showing.
thanks again.