I made all those changes except for:

ALTER TABLE phpwebgallery_categories
  ADD UNIQUE `categories_i3` (`permalink`);

I can't figure out how to add a unique.  I have little experience with phpmyadmin and sql in general.  The changes i made did help my problem though and i no longer have that error code at the beginning of my gallery.  If you could instruct me on how to add a unique i would be much appreciative.  Thanks.

I was able to make all of the other changes you requested.  The columns i have for the the categories table looks like this:

Last edited by krickett (2007-05-07 18:13:27)

Oh ok, i see what you are saying.  Yeah i have that below but it doesn't have the "categories_i3" keyname.  Ok so i just added that.  Now the lower section looks like this:



So i no longer have error codes when i go to my gallery main page but i'm still finding errors in other spots.

1.)  When i enter something in the quick search field, for example "wall" i get the below error, seen at http://4wdtoyota.com/gallery/index.php?/search/4 It still returns images matching the search word but displays the below error at the top of the gallery.

SELECT id, MATCH(ft) AGAINST( "wall" IN BOOLEAN MODE) AS q FROM (
SELECT
  i.id, CAST( CONCAT_WS(" ",
    IFNULL(i.name,""),
    IFNULL(i.comment,""),
    IFNULL(GROUP_CONCAT(DISTINCT co.content),""),
    IFNULL(GROUP_CONCAT(DISTINCT c.dir),""),
    IFNULL(GROUP_CONCAT(DISTINCT c.name),""),
    IFNULL(GROUP_CONCAT(DISTINCT c.comment),"") ) AS CHAR) AS ft
FROM (
  (
    phpwebgallery_images i LEFT JOIN phpwebgallery_comments co on i.id=co.image_id
  )
    INNER JOIN
  phpwebgallery_image_category ic on ic.image_id=i.id
  )
    INNER JOIN
  phpwebgallery_categories c on c.id=ic.category_id

GROUP BY i.id) AS Y
WHERE MATCH(ft) AGAINST( "wall" IN BOOLEAN MODE)
[mysql error 1064] You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT
  i.id, CAST( CONCAT_WS(" ",
    IFNULL(i.name,""),

2.) When i go to the history section of the Administration page, i get the below error at the top of the history page with history information displayed:

SELECT
    year,
    month,
    day,
    hour,
    max(id) AS max_id,
    COUNT(*) AS nb_pages
  FROM phpwebgallery_history
  WHERE summarized = 'false'
  GROUP BY
    year ASC,
    month ASC,
    day ASC,
    hour ASC
;
[mysql error 1054] Unknown column 'year' in 'field list'

My history table looks like this:

Last edited by krickett (2007-05-08 01:29:34)

krickett wrote:

1.)  When i enter something in the quick search field, for example "wall" i get the below error, seen at http://4wdtoyota.com/gallery/index.php?/search/4 It still returns images matching the search word but displays the below error at the top of the gallery.

We know that one already and we don't have the solution yet.

Temporary:

#mbMenu form#quicksearch { display: none; }

To add in ./template-common/local-layout.css (create that file if it didn't exist).

krickett wrote:

2.) When i go to the history section of the Administration page, i get the below error at the top of the history page with history information displayed:

I understand how to solve it. I don't know why you've got it.
I will give you steps to solve.
8-)

#mbMenu form#quicksearch { display: none; }

./template-common/local-layout.css

Create this file! With one line.
That's it!

8-)

I have zero experience with CSS and very little with coding in general so this is all new to me, but i'm slowly figuring out the basics.  Thanks for all your help.  I'll be looking forward to the other fixes.  Let me know when you get those figured out.

phpwebgallery_history:



I also have phptwebgallery_history_summary that has all the information that is being called when i go to the history section of the web gallery:

Last edited by krickett (2007-05-10 08:06:43)

krickett,

I am convinced that you installed a 1.7.0 above your previous version.
You never upgraded it.

That's the problem.
We will try to do missing steps.

_history ...

RENAME TABLE `phpwebgallery_history` TO `phpwebgallery_history_backup`;

CREATE TABLE `phpwebgallery_history` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `time` time NOT NULL default '00:00:00',
  `year` smallint(4) NOT NULL default '0',
  `month` tinyint(2) NOT NULL default '0',
  `day` tinyint(2) NOT NULL default '0',
  `hour` tinyint(2) NOT NULL default '0',
  `user_id` smallint(5) NOT NULL default '0',
  `IP` varchar(15) NOT NULL default '',
  `section` enum('categories','tags','search','list','favorites','most_visited','best_rated','recent_pics','recent_cats') default NULL,
  `category_id` smallint(5) default NULL,
  `tag_ids` varchar(50) default NULL,
  `image_id` mediumint(8) default NULL,
  `summarized` enum('true','false') default 'false',
  `image_type` enum('picture','high','other') default NULL,
  PRIMARY KEY  (`id`),
  KEY `history_i1` (`summarized`)
) TYPE=MyISAM;

After that
You still have an inconsistant Db.
Could you export tables structure from phpMyAdmin (Without data)?
And paste it in a post.
8-)

I got the file.
I broke the link to the doc.

I wasn't expecting that format but it is not a problem I will deal with that one.

I will analyze it. Up the topic, if no reply within 2 days.
8-)