Canīt install gigcalendar

[jemand]

Hello,
I would like to install the gigcalendar 4 my homepage, but it isnīt possible to install the component. If I try I get this message:

SQL Error DB function failed with error number 1067
Invalid default value for 'checked_out_time' SQL=CREATE TABLE IF NOT EXISTS `jos_gigcal_bands` ( `gigcal_bands_id` int(11) NOT NULL auto_increment, `published` tinyint(1) NOT NULL default '0', `thedefault` tinyint(1) NOT NULL default '0', `checked_out` tinyint(4) NOT NULL default '0', `checked_out_time` int(11) NOT NULL default '0000-00-00 00:00:00', `bandname` varchar(120) NOT NULL default '', `website` varchar(180) NOT NULL default '', `contactname` varchar(180) NOT NULL default '', `contactemail` varchar(180) NOT NULL default '', `contactphone` varchar(180) NOT NULL default '', `city` varchar(180) NOT NULL default '', `state` varchar(180) NOT NULL default '', `notes` text NOT NULL, PRIMARY KEY (`gigcal_bands_id`) );
SQL =

CREATE TABLE IF NOT EXISTS `jos_gigcal_bands` (
`gigcal_bands_id` int(11) NOT NULL auto_increment,
`published` tinyint(1) NOT NULL default '0',
`thedefault` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(4) NOT NULL default '0',
`checked_out_time` int(11) NOT NULL default '0000-00-00 00:00:00',
`bandname` varchar(120) NOT NULL default '',
`website` varchar(180) NOT NULL default '',
`contactname` varchar(180) NOT NULL default '',
`contactemail` varchar(180) NOT NULL default '',
`contactphone` varchar(180) NOT NULL default '',
`city` varchar(180) NOT NULL default '',
`state` varchar(180) NOT NULL default '',
`notes` text NOT NULL,
PRIMARY KEY
(`gigcal_bands_id`)
);

Can somebode help me please?

[jemand]

Nobody knows this problem?

[rhodan]

this (error 1067) usually excists if you try to install a second time.
Make sure the tables do not excist, delete them with phpmyadmin if necessary.
search the forum for solved bugs and apply them or download the latest nightly build.

then do a clean install.

cheers

[jemand]

Thank you.
But my english isnīt very well. Can you help me to delete the tables please?
Can you give some simple instructions?
After delete the calendar from the joomla backend I delete it manualy in the component/modul/bot-folders and then I tried to install the last version of gigcalendar. But it donīt work.

[rhodan]

you need to go to phpmyadmin
connect to your database in the left column
select all the tables from gigCalendar in the right pane
at the bottom there is a dropdown menu
select drop
click yes

tables are deleted.

uninstall the component and modules from the jommla backend.
that should do it.

[jemand]

I donīt why. but if I go to phpmyadmin and look into the sql of the site there are no entries of gig calendar?

[jemand]

I deleted the gigcalendar from the backend, but if I try to install the latest version of gigcalendar: "Another component is already using directory: "C:\Programme\xampp\htdocs\rg_relaunch\components\com_gigcal\".
But no component will be displayed in the backend?

[jemand]

Screenshot1

[jemand]

Screenshot2

[jemand]

Nobody knows?

[rhodan]

after uninstalling you need to check the directory on your c disk to make sure the folders are also gone....

I would suggest to use a free hosting site like www.byethost.com instead of xampp

I have it running on a free account there too and I am moderator of the support forum. I am more active there than I am here..

[jemand]

"\components\com_gigcal" is still there and "administrator\components\com_gigcal" is still there too!
Can I delete them manually?

regards

[rhodan]

yes, you need to delete them as I described in my post.

[Pruitt]

this (error 1067) usually excists if you try to install a second time.
Make sure the tables do not excist, delete them with phpmyadmin if necessary.
search the forum for solved bugs and apply them or download the latest nightly build.

then do a clean install.

cheers

I just tried to install Gig Calender for the first time and received this same exact error. I checked the DB and the Gig Calender table does not exist. I deleted both Gig Calender directories from my website, tried to reinstall and still get the same error.

I'd really like to use this component. My site is geared towards musicians. Does anyone have any ideas how I can solve this issue?   

[Capt. gigCal]

try the Nightly Builds at the JoomlaCode Development Site - let us know via this thread if that is helping with your installation. As rhodan said, be sure to start with a clean installation.