[Release] Jays UberCMS Edit

[HotelHoster]

Can some1 help me i got this Error
UberCMS has encountered an error
Table neti.site_cron' doesn't exist

Try uploading the database again and check that you are using the correct one. If that doesnt work run this sql:

DROP TABLE IF EXISTS `site_cron`;
CREATE TABLE `site_cron` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `prio` int(11) NOT NULL DEFAULT '5',
  `enabled` enum('0','1') NOT NULL DEFAULT '1',
  `scriptfile` varchar(50) NOT NULL,
  `last_exec` int(11) NOT NULL,
  `exec_every` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

 

[JayC]

Thanks @HotelHoster and run that sql he said to run

 

[bingxuan2009]

Great effort!

 

[XeroVoid]

Very nice release. Just having minor issues. Badge Shop refuses to work as it keeps saying "Stop! It seems you're currently logged into the hotel.Please close your client to continue."

When checking the database it seems the 'online' and 'last_online' columns aren't being updated with 'online' column staying at 1 (which is causing the above message) and 'last_online' to stay at 00:00:00.

I thought this would be an emu issue but after checking it says 'Connection Dropped [0] from 127.0.0.1' so it leads me to wondering whether it's a CMS issue. I'm on PHX 3.11 clean.

 

[JayC]

Very nice release. Just having minor issues. Badge Shop refuses to work as it keeps saying "Stop! It seems you're currently logged into the hotel.Please close your client to continue."

When checking the database it seems the 'online' and 'last_online' columns aren't being updated with 'online' column staying at 1 (which is causing the above message) and 'last_online' to stay at 00:00:00.

I thought this would be an emu issue but after checking it says 'Connection Dropped [0] from 127.0.0.1' so it leads me to wondering whether it's a CMS issue. I'm on PHX 3.11 clean.

You close the client and it works...
The database is a emulator error as mine works

 

[XeroVoid]

You close the client and it works...
The database is a emulator error as mine works

That's the problem, the client is closed but it still gives the message and still says 'users online 1'.
I'll look further into it to see if I can find out why it isn't being updated. If you have any insight it'd be appreciated.

Another issue I'm having though is in regards to HK. It keeps mentioning '

You must be registered for see links

I'm currently using a clean Phoenix 3.11 DB that was released on this forum with the source. Everything else works but I keep getting those errors.

All other issues I'm having are in regards to the SWF you provided linking to a lot of pages that don't exist. So hopefully I can find an updated SWF that has groups support as I've noticed the groups table in the Phx DB.

 

[BenHands]

@JayCustom Nice to you edited some of the old thread, however. I still liked the old index from the old thread. Can that still be used?

 

[jordansc1996]

Jay Help me out bro

 

[Timothy]

Jay Help me out bro

U need navigator_pubcats in your database. you dont have it. -.-

 

[jordansc1996]

U need navigator_pubcats in your database. you dont have it. -.-

Could you Give me a link to download it or Tell me where i can get It Please?

 

[Timothy]

Could you Give me a link to download it or Tell me where i can get It Please?

Here you go. Hope it works if not message me.

-- Table structure for table `navigator_pubcats`
--

DROP TABLE IF EXISTS `navigator_pubcats`;
CREATE TABLE IF NOT EXISTS `navigator_pubcats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `caption` varchar(100) NOT NULL,
  `enabled` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `navigator_pubcats`
--

INSERT INTO `navigator_pubcats` (`id`, `caption`, `enabled`) VALUES
(1, 'Cafes and Restaurants', '1'),
(2, 'Lounges and Entertainment', '1'),
(3, 'Pubs and Clubs', '1'),
(4, 'Outside Spaces & Swimming Pools', '1');

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

 

[jordansc1996]

Here you go. Hope it works if not message me.

-- Table structure for table `navigator_pubcats`
--

DROP TABLE IF EXISTS `navigator_pubcats`;
CREATE TABLE IF NOT EXISTS `navigator_pubcats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `caption` varchar(100) NOT NULL,
  `enabled` enum('0','1') NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `navigator_pubcats`
--

INSERT INTO `navigator_pubcats` (`id`, `caption`, `enabled`) VALUES
(1, 'Cafes and Restaurants', '1'),
(2, 'Lounges and Entertainment', '1'),
(3, 'Pubs and Clubs', '1'),
(4, 'Outside Spaces & Swimming Pools', '1');

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

Piss Take! it worked now it says this -_-

 

[Timothy]

Piss Take! it worked now it says this -_-

idk. never seen that before. Download a new uber database. :L

 

[jordansc1996]

idk. never seen that before. Download a new uber database. :L

lol its a piss take can u link me to one?

 

[Timothy]

lol its a piss take can u link me to one?

Here.

You must be registered for see links

 

[jordansc1996]

Here.

Will Phoenix Emulator work on it?

 

[Timothy]

Will Phoenix Emulator work on it?

Im sure it will. If not i will look at a new one for u.

 

[jordansc1996]

Im sure it will. If not i will look at a new one for u.

Keep saying this ?

 

[Timothy]

Keep saying this ?

Did u re-register when u uploaded the new db? And/or does your ip match 127.0.0.1....

 

[jordansc1996]

yes re-registerd what you mean dose ur ip match 127.0.0.1?