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)
Offline
Just below you have :
Indexes: Documentation
Keyname Type .... Field
PRIMARY PRIMARY ... id
categories_i3 UNIQUE ... permalink
categories_i2 INDEX ... id_uppercat
Create an index on ...
?
Offline
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)
Offline
Any ideas on how to solve these last 2 problems? I'd really like to get all of these issues fixed. Thanks again for all of your help!
Offline
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-)
Offline
Ok, i'll wait until i get more information from you to fix the 2nd problem. As far as solving problem 1, what do you mean by:
Temporary:
#mbMenu form#quicksearch { display: none; }
To add in ./template-common/local-layout.css (create that file if it didn't exist).
Do you just want me to create the file "local-layout.css" in the template-common folder? I don't understand what i'm supposed to do with the first line that says: #mbMenu form#quicksearch { display: none; }
If you could explain this fix some more that would be very helpful.
Offline
#mbMenu form#quicksearch { display: none; }
./template-common/local-layout.css
Create this file! With one line.
That's it!
8-)
Offline
CSS code is complex.
But sometimes it's simple.
8-)
Offline
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.
Offline
HISTORY Problem.
Could you show me the structure of your phpwebgallery_history table?
8-)
Offline
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)
Offline
I know which tables you have... http://forum.phpwebgallery.net/viewtopi … 311#p59311
8-)
Offline
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-)
Offline
I ran the upgrade EXACTLY as it says in the readme file. Why it didn't perform i do not know. I even ran it again to make sure and it said that the database had already been upgraded. I hope we can get this problem resolved. Thank you again for your patience with me and for helping me through this.
I made the changes you posted. I now have a table named "phpwebgallery_history' that looks like:
I already had a table named "phpwebgallery_history_backup" with the same information as "phpwebgallery_history" so i renamed "phpwebgallery_history" to "phpwebgallery_history_backup7" incase i need it again later. "phpwebgallery_history" was then created as you instructed.
I hope this is correct, i believe i copied everything exact. Again, i'm new to php and sql so i'm trying my best but this is all VERY new to me. I don't get any errors now on the history page but i also don't see any data in there. I'm sure it takes some time for information to show up.
I was able to export the structure of the database into a word document. My database also has a wordpress install on it, but i did not include those in the structure since you won't need those.
The file can be found at http://www..... Broken link for security reasons
Thanks again,
-Ryan
Last edited by VDigital (2007-05-14 08:30:31)
Offline
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-)
Offline