Author Topic: DB Error after installing 1.7.6  (Read 4436 times)

0 Members and 1 Guest are viewing this topic.

Offline charly22

  • Jr. Member
  • **
  • Posts: 64
    • View Profile
DB Error after installing 1.7.6
« on: February 08, 2008, 12:08:44 AM »
Hi
I just installed 1.7.6 and before I had 1.7.1.
now, after I am logged in nas admin and when I open a picture I get following error message on top of the page:

Quote
DB Error: Bad SQL Query: SELECT c.comment_id, c.image_id, c.user_id, c.user_name AS comment_user_name, c.comment_headline, c.comment_text, c.comment_ip, c.comment_date, u.user_level, u.user_name, u.user_email, u.user_showemail, u.user_invisible, u.user_joindate, u.user_lastaction, u.user_comments, u.user_homepage, u.user_icq FROM 4images_comments c LEFT JOIN 4images_users u ON (u.user_id = c.user_id) WHERE c.image_id = 138 ORDER BY c.comment_date ASC
Unknown column 'c.comment_text' in 'field list'

Any idea what went wrong and what I can do?
Thanks
Charly22

Offline nobby

  • 4images Guru
  • *******
  • Posts: 2.873
    • View Profile
Re: DB Error after installing 1.7.6
« Reply #1 on: February 08, 2008, 08:44:42 AM »

Offline charly22

  • Jr. Member
  • **
  • Posts: 64
    • View Profile
Re: DB Error after installing 1.7.6
« Reply #2 on: February 12, 2008, 05:05:49 PM »
Hi, is it possible to delete the whole database or do a reset and set it up correctly again. How do I do that?
Since I have 1.7.6 I face major issues.
Thanks
Kaan

Offline charly22

  • Jr. Member
  • **
  • Posts: 64
    • View Profile
Re: DB Error after installing 1.7.6
« Reply #3 on: February 12, 2008, 05:17:53 PM »
when i click on most pictures I get following error message
Quote
Template Error: Couldn't open Template ./templates/4default_wide/exif_bit.html
Where do I need to look in?

Offline mawenzi

  • 4images Moderator
  • 4images Guru
  • *****
  • Posts: 4.500
    • View Profile
Re: DB Error after installing 1.7.6
« Reply #4 on: February 12, 2008, 05:35:31 PM »
... you don't have a exif_bit.html in your actual template folder ... !
... copy a exif_bit.html from /templates/default/ folder in to your /templates/4default_wide/ folder ...
Your first three "must do" before you ask a question ! ( © by V@no )
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

You are on search for top 4images MOD's ?
- then please search here ... Mawenzi's Top 100+ MOD List (unsorted sorted) ...