Problems with zoom gallery module

kachete · 29.01.2005, 04:13

Hi

I download and install the new zoom version for 4.5.1.a and installed it

I also installed the module that gave me and error

Code:

 Notice: Table 'eldiario_datos.mos_zoom_config' doesn't exist in /home2/eldiario/public_html/includes/database.php on line 184
 
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home2/eldiario/public_html/modules/mod_zoom.php on line 29
 
Warning: mysql_result(): supplied argument is not a valid MySQL result resource in /home2/eldiario/public_html/modules/mod_zoom.php on line 30

So i found that it dont exits a table

I found in a also a module that have a script to update the mambo database in order to put the module to work

I try to insert the query into the database and i got this error

Code:

 
#1146 - Table 'eldiario_datos.mos_zoom_config' doesn't exist

so i asume it dont have the table created in the instalation

the code is this into the query

Code:

 
 
# update_module.sql
# 
# date: 01-07-2004
# author: Mike de Boer
# This query works ONLY if you have an incomplete update 
# from zOOm Image Gallery v2.0 OR v2.1.1.
#
# To update your #__zoom_config table, please execute the
# following SQL command:
#
# NOTE: if you have a different table-prefix than "mos_",
# you should change it to whatever you're using.
ALTER TABLE `mos_zoom_config` ADD zoomModule tinyint( 1 ) unsigned NOT NULL default '2'

the main reason for ask is i dont know how to create a table into the database becaouse i dont know nathing of the mysql

Please can you help me here

Please

Thanks

quiquedcode · 29.01.2005, 18:15

these problems were generated by K3's Playground modules ?

Code:

http://mamboforge.net/frs/?group_id=355

kachete · 29.01.2005, 20:20

When you install the new version it have some bugs in the instalation core

And it happend that in the installation script a table for the module to work dont be created

In the patch to the new version of the module the query to the script dont create the table

thats the problem

can anyone help us here

Please

quiquedcode · 29.01.2005, 23:49

maybe by contacting its developer trhough mamboforge...

sacr0 · 30.01.2005, 00:26

The module from zoom is for the later version of Zoom Gallery for Mambo 4.5.
It won't work straight away for the new version of Zoom gallery because this version doesn't intall its config values to a table in the database but reads them from a file instead.

An easy way around this is to uninstall your zoom gallery.

Install the 4.5 version ( the tables are installed )

Go to the Zoom Configuration and make sure your settings are right.

Then UNINSTALL the zoom gallery. ( I don't think it uninstalls the tables )

Then install the new gallery and do the settings in the config area again.

Your Zoom Module will work now.

Another way would be to manually insert the zoom config table from the old version and enter the settings manually or to update the module to use the config file instead of the database table. Both are more complicated than the first though.

kachete · 30.01.2005, 18:31

I do what you have tell here

I install and old version of the script and the module work

When i unistall the script and install the new script the tables dotn show

so the solution dont work

the other solution i dont think i can achieve becouse i dont know many of the programing skills i think we have to have

Please help us here with a straigth solution

Thanks