Announcement

#16 2007-05-07 18:11:52

krickett
Member
2007-02-07
26

Re: Upgrade 1.6.x to 1.7.x

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:
http://www.4wdtoyota.com/sqltable.jpg

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

Offline

 

#17 2007-05-07 20:24:35

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

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 ...

?


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

#18 2007-05-07 22:44:49

krickett
Member
2007-02-07
26

Re: Upgrade 1.6.x to 1.7.x

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:

http://www.4wdtoyota.com/lower.jpg

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.

Code:

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:

Code:

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:

http://www.4wdtoyota.com/history.jpg

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

Offline

 

#19 2007-05-09 02:31:47

krickett
Member
2007-02-07
26

Re: Upgrade 1.6.x to 1.7.x

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

 

#20 2007-05-09 08:32:41

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

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-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

#21 2007-05-10 00:39:58

krickett
Member
2007-02-07
26

Re: Upgrade 1.6.x to 1.7.x

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

 

#22 2007-05-10 00:55:54

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

#mbMenu form#quicksearch { display: none; }

./template-common/local-layout.css

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

8-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

#23 2007-05-10 00:57:42

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

CSS code is complex.
But sometimes it's simple.
8-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

#24 2007-05-10 07:15:47

krickett
Member
2007-02-07
26

Re: Upgrade 1.6.x to 1.7.x

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

 

#25 2007-05-10 07:39:30

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

HISTORY Problem.

Could you show me the structure of your phpwebgallery_history table?
8-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

#26 2007-05-10 08:03:18

krickett
Member
2007-02-07
26

Re: Upgrade 1.6.x to 1.7.x

phpwebgallery_history:

http://www.4wdtoyota.com/history_table

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:

http://www.4wdtoyota.com/history_summary

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

Offline

 

#27 2007-05-10 08:09:32

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

I know which tables you have... http://forum.phpwebgallery.net/viewtopi … 311#p59311
8-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

#28 2007-05-12 09:24:59

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

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-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

#29 2007-05-14 07:49:34

krickett
Member
2007-02-07
26

Re: Upgrade 1.6.x to 1.7.x

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:
http://www.4wdtoyota.com/newhistory

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

 

#30 2007-05-14 08:35:16

VDigital
Former Piwigo Team
Paris (FR)
2005-05-04
17680

Re: Upgrade 1.6.x to 1.7.x

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-)


Piwigo.com: Start and run your own photo gallery. Signup and get 30 days to try for free, no commitment.
8-)

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2019 · Contact