Plugin Gk-Vm header php and xml

Hello, i installed joomla 1.5.7 bundled with the virtumart eccommerce package (joomla + virtuemart),. i installed the component but when i try installing the plug ins, i get the following error,
* Installer cann't add new column in databaseALTER TABLE #__gk_photoslide_groups ADD `mediumThumbX` int(11) NOT NULL DEFAULT 0;
need help
thanks

you've installed only clean joomla with VM and photoslide ? it seems strange, because clean install of Photoslide hasn't this column in database - you can see bug like this after problems with uninstalling plugins...

im sorry still have not understand how to solve the issue. i used the ecommerce v ersion of joomla from virtumart, then i installed the component. when i tried to instal the plug ins i got this error. how can i solve it?
thanks

... have the same problem and did not understand the answer ...

seems like gavick guys are unable to provide a solution, i have also emailed them afor support regarding the above but no reply. can you please tell me how can i solve my problem!!?

... Please download again package with our download area for member (rest files) and try install photoslide and module plugin - I downloaded it yesterday and I've checked component SQL install file and plugin XML file - IT MUST WORKS because mediumThumbX column is exist in this files only once time in plugin XML file - if it doesn't works - try reinstall again photoslide and check manually MySQL database in PHPMyAdmin - if you see some photoslide tables then remove it...

im sorry,, still i cannot understand what i have to do. not all of us are programmers, that is why we buy templates and components from you.. still the error is the following:

Installer cann't add new column in databaseALTER TABLE #__gk_photoslide_groups ADD `mediumThumbX` int(11) NOT NULL DEFAULT 0;

Did you do it with PHOTOSLIDE GK1 ?

i have used the download files of the eshotrix ii package com_gk_photoslide

Ok, so you have access on your hosting to operation ALTER TABLE ?

yes i have

Do you have in your Joomla! database some Photoslide tables (each table has phrase "photoslide" in name ) after uninstall ? I understand that you have installed Photoslide now, so before potential uninstall check columns in photoslide groups table - do you have column mediumThumbX in this table ? Do you have other columns ? Check this things in PHPMyAdmin or MySQL console...

after the unistall no table exist with the name photoslide

Ok, and what about database after photoslide installation ?

check columns in photoslide groups table - do you have column mediumThumbX in this table ? Do you have other columns ?

after installation there is no table by that name. also after uninstalling and installing i get a new error now


* Installer cann't add new column in databaseALTER TABLE #__gk_photoslide_slides ADD `file` varchar(110) NOT NULL DEFAULT '';

Did you look earlier for "check system" page on component ? You must run install SQL file manually - if you haven't in database photoslide tables run this SQL queries in PHPMyAdmin (it fix problem with file column and don't forgot about changing #__ for your Joomla databases prefix for example jos_):

Code: Select all

DROP TABLE IF EXISTS `#__gk_photoslide_groups`;
DROP TABLE IF EXISTS `#__gk_photoslide_slides`;
DROP TABLE IF EXISTS `#__gk_photoslide_plugins`;

CREATE TABLE `#__gk_photoslide_groups` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(128) NOT NULL,
  `plugin` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE `#__gk_photoslide_plugins` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(128) NOT NULL,
  `status` int(11) NOT NULL,
  `type` varchar(128) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `phpclassfile` varchar(255) NOT NULL,
  `version` varchar(128) NOT NULL,
  `author` varchar(128) NOT NULL,
  `desc` mediumtext NOT NULL,
  `gfields` mediumtext NOT NULL,
  `sfields` mediumtext NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

CREATE TABLE `#__gk_photoslide_slides` (
  `id` int(11) NOT NULL auto_increment,
  `group_id` int(11) NOT NULL,
  `name` varchar(128) NOT NULL,
  `order` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;


hello, sorry again the same problem, can i email you cpanel ACCEss, to see ur self.?

ok - send it for dziudek[at]gavick[dot]com

If somebody else has problem like this:
- please check your database after installation - it contains Photoslide tables ? If not - please install manualy tables through running component install SQL file in PHPMyAdmin or MySQL console.
- please check your access to function ALTER TABLE on your hosting
- please use attached plugin XML file (please unpack before upload in component)

The problem was field "file" in 'jos_gk_photoslide_slides` SQL data base. It should be removed.