127 Posts
Cappu
7 years ago
7
Topic

Hi,

I am somehow stuck. I do have several seblod form & content types. Everythings works fine, besides with just one the  form & content types it's currently not possible to create a new dataset.

[Edit] Hitting Save button endlessly tries to connect to the server - no error message

I checked the PHP settings:

max_input_vars 3000

memory_limit 1280M

post_max_size 1280M

The form & content type has approx 60 fields. On the respective form & content type I used the Seblod Importer to import approx. 25.000 dataset without a problem. I can edit existing datasets. - It's just that I cannot create new ones, neither in the Backend nor in the Frontend.

Temporarily I removed allmost all fields out of the form, no success. 

I checked the user rights; this occurs on Super User, too.

Any ideas what could cause a problem like this. How could I debug such an error?

Thanks for any hint.

Get a Book for SEBLOD
4229 Posts
Kadministrator
7 years ago
6
Level 1

Endless connect to the server indicates server is blocking your request for some reason or it crashes on request. Ask your hosting provider if they use some protection system that might interfere with it and/or if there are any errors in the error log.

127 Posts
Cappu
7 years ago
5
Level 2

Hi Klas,

thanks for your hint. - Called the provider and checked error logs. - Tested different PHP Versions with and without FastCGI - no success so far.

The Apache error log just prints out the following messages:

[warn] ... (104)Connection reset by peer: mod_fcgid: error reading data from FastCGI server, referer: http://myserver.xx/add-dataset
[error] ... Premature end of script headers: index.php, referer: http://myserver.xx/add-dataset

Please, could you give me a hint, in which scripts to place some JLog statements to get more infos from the Joomla side?

127 Posts
Cappu
7 years ago
4
Level 3

Hi,

I could trace the bug to the following line:

/libraries/cck/base/form/store_inc.php line 263

$dispatcher->trigger( 'onCCK_Storage_LocationStore', array( $data['_']->location, $data, &$config, $id ) );

Any ideas on what may block the script in the respective onCCK_Storage_LocationStore for an Article Form& Content type here?

127 Posts
Cappu
7 years ago
3
Level 4

Digging deeper and deeper I finally found the blocking routine:

/plugins/cck_storage_location/joomla_article/joomla_article.php arround line 542:

} elseif ( $ordering > -1 ) {
  $table->reorder( 'catid = '.(int)$table->catid.' AND state >= 0' );
}

The $table->catid returns a valid id. The $table->reorder seems to have ressource problems with either the fiedlnames or the approx. 25.000 datasets.

Any idea on how to overcome this issue?!

Thanks for any idea.


4229 Posts
Kadministrator
7 years ago
0
Level 5

HI,

I'm afraid as this is Joomla function, your only option is to increase available resources. You should report a bug on joomla tracker as well.

127 Posts
Cappu
7 years ago
1
Level 5

Seems to be a known issue in Joomla's JTable->reorder routine

https://issues.joomla.org/tracker/joomla-cms/11184
https://docs.joomla.org/API16:JTable/reorder

Uncommenting this line of code fixes the problem. Could this may have negative side effects in Seblod?

4229 Posts
Kadministrator
7 years ago
0
Level 6

Commenting them out should only impact order probalably.

Get a Book for SEBLOD