Comments won't display please help urgently

[krupa]

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

[Nibbler]

Recreate it using phpMyAdmin.

Code Select Expand


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


[krupa]

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

thanks heaps

[krupa]

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

[krupa]

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'

[krupa]

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

[Joe Carver]

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]

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

[krupa]

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?

[Nibbler]

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

[krupa]

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