forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 install => Topic started by: krupa on November 03, 2010, 02:47:03 pm

Title: Comments won't display please help urgently
Post by: krupa 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

Title: Re: Comments won't display please help urgently
Post by: Nibbler 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';


Title: Re: Comments won't display please help urgently
Post by: krupa 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

Title: Re: Comments won't display please help urgently
Post by: krupa 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

Title: Re: Comments won't display please help urgently
Post by: krupa 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'

Title: Re: Comments won't display please help urgently
Post by: krupa 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

Title: Re: Comments won't display please help urgently
Post by: Joe Carver 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.

Title: Re: Comments won't display please help urgently
Post by: krupa 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

Title: Re: Comments won't display please help urgently
Post by: krupa 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?

Title: Re: Comments won't display please help urgently
Post by: Nibbler 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.

Title: Re: Comments won't display please help urgently
Post by: krupa 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.