| Re: Module advice |
| by robertico on 2005/8/25 9:09:22 For XOOPS 2.2.2 use myAlbum-P 2.85 (Installing 2.9 gives a 2.85 vesion) Download: http://www.peak.ne.jp/support/xoops/ Installed without errors 
|
| Re: Module advice |
| by robertico on 2005/8/24 13:13:49 Spend some time finding out why myAlbum-P (2.84) gives an error with mySQL 5.0. Found a missing default value for res_x and res_y [FIX] Edit next files in /myalbum/sql/ - myalbum.sql - myalbum0.sql - myalbum1.sql - myalbum2.sql Search for: - res_x int(11) NOT NULL default '', Replace: - res_x int(11) NOT NULL default '0', - res_y int(11) NOT NULL default '0', Now install myalbum without errors
|
| Re: Module advice |
| by robertico on 2005/8/23 14:19:38 [Mithrandir] Tried myAlbum-P in the meantime as suggested. But still haven't an album  With reference to xcGallery, what do you need to advice me for this. The complete php debug list (large)?? (A lot of this:) Notice [PHP]: Only variable references should be returned by reference in file kernel/object.php line xxx Notice [PHP]: Only variables should be assigned by reference in file kernel/object.php line xxx [dargosch] With reference to myAlbum-P. What's your version of mySQL server? If it's a mySQL 5.0 server problem, is it possible to fix it ? |
| Re: Module advice |
| by Mithrandir on 2005/8/23 12:22:03 Quote: Already did. We were troubleshooting xcGallery, right? If you are sure that you want to go with MyAlbum instead (which is also a very good choice - but I don't know many of the other gallery modules, so can't compare) you can do what GIJOE suggested. I believe this is a MySQL 5.0 problem. |
| Re: Module advice |
| by robertico on 2005/8/23 11:46:47 Already did. - php.ini register_globals=on - php version 4-4.4.0 - mysql-server version 5.0.9_1 - OS FreeBSD - etc... A lot of php [notice] warnings (already before install). mySQL debug: le="color: #000000"><?php [color=CC0000]CREATE TABLE H478ZR_myalbum_photos ( lid int(11) unsigned NOT NULL auto_increment, cid int(5) unsigned NOT NULL default '0', title varchar(100) NOT NULL default '', ext varchar(10) NOT NULL default '', res_x int(11) NOT NULL default '', res_y int(11) NOT NULL default '', submitter int(11) unsigned NOT NULL default '0', status tinyint(2) NOT NULL default '0', date int(10) NOT NULL default '0', hits int(11) unsigned NOT NULL default '0', rating double(6,4) NOT NULL default '0.0000', votes int(11) unsigned NOT NULL default '0', comments int(11) unsigned NOT NULL default '0', PRIMARY KEY (lid), KEY cid (cid), KEY status (status), KEY title (title(40)) ) TYPE=MyISAM Error number: 1067 Error message: Invalid default value for 'res_x' ( 0.000877)[/color] I found this link (bug ??): http://www.peak.ne.jp But what's the solution ? 
|
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|