husain .. ma man..

i'm getting an sql error.. when i try to manage comps and or enter new ones..

i've upgraded my hack from the old version "that was working fine" to the new one.. hmmm

okay now it is working fine.. i had to uninstall the plugin and reinstall it again..

i lost some data .. but that is okay... nothing important..

hope this doesn't happen when i have a bigger competition database.. looll

problem vbulletin 3,.5.4

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT competitionid, title, startdate, enddate, winnercount, is_enabled
FROM vb3_hkc_competitions
ORDER BY startdate DESC, enddate DESC;

MySQL Error : Unknown column 'startdate' in 'field list'
Error Number : 1054
Date : Monday, April 17th 2006 @ 11:38:41 PM
Script : http://www.clubx360.it/forum/admincp....php?do=modify
Referrer : http://www.clubx360.it/forum/admincp/index.php?do=nav
IP Address :
Username :
Classname : vb_database

-- phpMyAdmin SQL Dump
-- version 2.6.3-pl1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: 18 Apr, 2006 at 10:16 AM
-- Versione MySQL: 3.23.58
-- Versione PHP: 5.0.4
--
-- Database: `IPB`
--

-- --------------------------------------------------------

--
-- Struttura della tabella `vb3_hkc_competitions`
--

CREATE TABLE `vb3_hkc_competitions` (
`competitionid` smallint(5) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` mediumtext NOT NULL,
`type` enum('input','select','radio','textarea','checkbox ','select_multiple') NOT NULL default 'input',
`data` mediumtext NOT NULL,
`maxlength` smallint(6) NOT NULL default '250',
`size` smallint(6) NOT NULL default '25',
`height` smallint(6) NOT NULL default '0',
`optional` smallint(5) unsigned NOT NULL default '0',
`def` smallint(6) NOT NULL default '0',
`regex` varchar(255) NOT NULL default '',
`enddate` int(10) unsigned NOT NULL default '0',
`datestamp` int(10) unsigned NOT NULL default '0',
`correctanswer` mediumtext NOT NULL,
`entrycount` mediumint(8) unsigned NOT NULL default '0',
`maxentries` smallint(5) unsigned NOT NULL default '1',
`maxwinners` smallint(5) unsigned NOT NULL default '1',
`winnercount` smallint(5) unsigned NOT NULL default '0',
`enableguidelines` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`competitionid`),
KEY `enddate` (`enddate`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dump dei dati per la tabella `vb3_hkc_competitions`
--


-- --------------------------------------------------------

--
-- Struttura della tabella `vb3_hkc_entries`
--

CREATE TABLE `vb3_hkc_entries` (
`entryid` int(10) unsigned NOT NULL auto_increment,
`competitionid` smallint(5) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`answer` mediumtext NOT NULL,
`entrydate` int(11) NOT NULL default '0',
PRIMARY KEY (`entryid`),
KEY `competitionid_userid` (`competitionid`,`userid`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

--
-- Dump dei dati per la tabella `vb3_hkc_entries`
--


-- --------------------------------------------------------

--
-- Struttura della tabella `vb3_hkc_winners`
--

CREATE TABLE `vb3_hkc_winners` (
`competitionid` smallint(5) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`competitionid`,`userid`)
) TYPE=MyISAM;

--
-- Dump dei dati per la tabella `vb3_hkc_winners`
--

the querry non funzionano !!!!

I'm currently on vB version 3.5.2 (patched)
Do i need to upgrade to use this hack?

There is no need to upgrade for this hack to work.

I think you have an older version of the hack with new PHP files. If your products page shows any version less than 1.0.2, please download the ZIP file again, and reinstall the hack. Make sure you check the box that says "Allow Overwrite".

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT competitionid, title, startdate, enddate, winnercount, is_enabled
FROM vb3_hkc_competitions
ORDER BY startdate DESC, enddate DESC;

MySQL Error : Unknown column 'startdate' in 'field list'
Error Number : 1054
Date : Tuesday, April 18th 2006 @ 01:30:54 PM
Script : http://www.clubx360.it/forum/admincp....php?do=modify
Referrer : http://www.clubx360.it/forum/admincp/index.php?do=nav
IP Address : 213.xxx.xxx.xxx
Username : SWANTONIO
Classname : vb_database

no non funziona :ermm:

I set up a test competition.
I, myself, participated in it... as soon as i voted i received a pm informing me of my competition. Now, is sais: (in the main forum page)

Welcome, {Nickname}.
You last visited: Today at 11:20
Private Messages: Unread 29, Total 635.
No pop-up for them, i logged out and logged in again, no change, i still have 29 unread pms which i can't find.

Any thought?

Edit:
I just found them, the oldest 29 was marked as unread.
But why? For sure, this happened after i received the "thank you" pm and send the report back (ok, the report came to me).

also, one question.
As soon as the Competitions comes to an end, what happens then?
:)