Backend Problem - Cannot Edit

Benvenuto, Ospite

(1 Online) (1) Ospite

Pagina:
1

ARGOMENTO: Backend Problem - Cannot Edit

Backend Problem - Cannot Edit 14 Anni, 8 Mesi fa #430

breeke
Offline
Fresh Boarder
Messaggi: 1

Thanks for the great component!

I'm experiencing some weird issues at the backend.

When I click on an item, there is an error :

* The list /xxxxx is currently being edited by another administrator

Another problem :

Cannot publish/unpublish. Clicking on the X or Tick has no effect.

Only Delete and Copy is working.

Tools > Global Check-In does not help either.

Hope you can help as this is really a very useful component.

By the way, I'm having the exact same problems with Tag Meta too.

L'Argomento è stato bloccato.

Re:Backend Problem - Cannot Edit 14 Anni, 8 Mesi fa #433

admin Offline Administrator Messaggi: 1603	Could you please send me dump of your ReDJ and Tag Meta table? I can guess the problem (I have fixed in 1.3, not released yet), but I want to be sure. Thanks, Luigi
	Ultima modifica: 14 Anni, 8 Mesi fa Da admin. L'Argomento è stato bloccato.

Re:Backend Problem - Cannot Edit 14 Anni, 5 Mesi fa #857

leo
Offline
Fresh Boarder
Messaggi: 4

I also have this problem.

When I click on one of the ReDJ Manager Items, it says:

The list /signup.html is currently being edited by another administrator

When I go to Tools > Global Check-In is says the items gets checked in, but when I click on another ReDJ item it again says:

The list /signup.html is currently being edited by another administrator

The jos_redj table 'checked_out' column contains '127'.

I've attached an export of jos_redj.cvs

L'Argomento è stato bloccato.

Re:Backend Problem - Cannot Edit 14 Anni, 5 Mesi fa #864

admin Offline Administrator Messaggi: 1603	I can't see the attached file. You can send me an email (address in contattaci menu item on the left). Luigi
	L'Argomento è stato bloccato.

Re:Backend Problem - Cannot Edit 14 Anni, 5 Mesi fa #867

leo Offline Fresh Boarder Messaggi: 4	Here's a link to download it: senduit.com/efa2dd
	L'Argomento è stato bloccato.

Re:Backend Problem - Cannot Edit 14 Anni, 5 Mesi fa #889

admin Offline Administrator Messaggi: 1603	Sorry for delay (I was out of office). Anyway, I need the sql dump just because your problem could be related to an old table structure. If you export a CSV file, I can just check for configured items, but can't see sql table "create". Could you post it? Luigi
	L'Argomento è stato bloccato.

Re:Backend Problem - Cannot Edit 14 Anni, 5 Mesi fa #893

leo
Offline
Fresh Boarder
Messaggi: 4

create table `jos_redj` (
	`id` double ,
	`fromurl` varchar (765),
	`tourl` varchar (765),
	`hits` double ,
	`ordering` double ,
	`published` tinyint (1),
	`checked_out` tinyint (1),
	`checked_out_time` datetime 
); 
insert into `jos_redj` (`id`, `fromurl`, `tourl`, `hits`, `ordering`, `published`, `checked_out`, `checked_out_time`) values('1','/signup.html','http://www.XXX.com/offer.html','214','1','1','127','2009-12-01 09:16:35');
insert into `jos_redj` (`id`, `fromurl`, `tourl`, `hits`, `ordering`, `published`, `checked_out`, `checked_out_time`) values('2','/help','http://www.XXX.com','18','2','1','0','0000-00-00 00:00:00');
insert into `jos_redj` (`id`, `fromurl`, `tourl`, `hits`, `ordering`, `published`, `checked_out`, `checked_out_time`) values('7','/support','http://www.XXX.com','11','3','1','127','2009-12-01 09:16:41');

L'Argomento è stato bloccato.

Re:Backend Problem - Cannot Edit 14 Anni, 5 Mesi fa #895

admin
Offline
Administrator
Messaggi: 1603

Two notes.
First, drop the host part from items. ReDJ works with REQUEST_URI (e.g. for www.yoursite.com/home.html just put /home.html in item's "From URL").

Then, as I sayed, you have an old table structure. The last one is the following:

CREATE TABLE IF NOT EXISTS `#__redj` (
  `id` int(11) NOT NULL auto_increment,
  `fromurl` varchar(255) NOT NULL default '',
  `tourl` varchar(255) default NULL,
  `hits` int(11) unsigned NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  `published` tinyint(1) NOT NULL default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idxfromurl` (`fromurl`)
) type=MyISAM default CHARSET=utf8 ;

As you can see, checked_out must be an integer, and not a tinyint (this cause the lock problem). You can try to create it manually replacing your real prefix in table name, or just uninstall component and reinstall the last version. Then, check table structure if the ALTER TABLE in the install script has worked. Maybe you have an old MySQL version (e.g. 4.x) and this can cause problems.

Regards,
Luigi

Ultima modifica: 14 Anni, 5 Mesi fa Da admin.

L'Argomento è stato bloccato.

Re:Backend Problem - Cannot Edit 14 Anni, 5 Mesi fa #897

leo Offline Fresh Boarder Messaggi: 4	Thank you Luigi. I changed 'checked_out' to int and now it works. Thanks for you help!
	L'Argomento è stato bloccato.

Pagina:
1

Forum

Joomla!

ReDJ (in English)

Moderatori: admin

Tempo generazione pagina: 0.93 secondi