SP Page Builder 5 RC2 is Released

hello,
i have error 500 too,
but i don't understand what you mean about F12 "developper console"

Thx for help

Hi Guillaume,

sorry for the late reply.
The developer console is a feature of most browsers today.
Chrome, Firefox, ...

If you press F12 while your browser is focused, the console should open.
If you are using a MAC with safari, then it is Option + ⌘ + J (on macOS).

-> https://kulturbanause.de/blog/die-chrome-entwicklertools-devtools-fuer-designer-und-einsteiger/
-> https://medium.com/swlh/the-basics-of-chrome-devtools-4d69a102a699

I hope this explains what I meant and sorry again for the late reply.

Fehler
SQL-Befehl: Kopieren


ALTER TABLE `jos_sppagebuilder` ADD `content` mediumtext AFTER `text`;
MySQL meldet: Dokumentation

#1067 - Fehlerhafter Vorgabewert (DEFAULT) für 'created_on'

@Shoomshaper team, please make sure this is taken into consideration.
Translation with SP Page Builder Translation plugin is a MUST for us.

Hi,

I have build a pre release version with only a few addon's (v5 compatible)
how can i send you this file ?
Kawshar Ahmed never contact me and the other contact i have from Joomshaper don't respond

Stéphane
faboba.com

Hi,
thanks but i have double-tripple check and i don't see hidden content
i put my mail in the hidden content of this post

Stéphane

Yes, that is working :)

Thank you for providing this quick and dirty solution for the other users.
Now the other users can continue testing to see if there are any other problems.

And yes, Joomshaper needs to fix that urgently.

Thanks again and have a great day and weekend everyone.

Hello Geoffrey,

I did the same test with your website, only switching the location in GTmetrix and got the same differences.
This looks more like a result of the different locations instead of SPPB 5.
-> Test Server Location "London vs Vancouver"

Please run the test again with the same test server location and different sppb version.
That we can see here a direct difference of the versions, which is not falsified by the server location.

Have a nice day and weekend.

Dear Sajeeb Ahamed,

it was a pleasure to help your customers locate the issues so that they can do further testing for you without having to wait for the next RC release.

Actually, you as support should help here before the next RC release that the customers can test further and determine possible further problems.

This is so frustrating with support. :(

hi, the problem is that there seems to be tables which are not "conforn" to new MySQL Rules like the predefine date, and NOT NULL Arguments, ... That all has to be verfied by Joomshaper that their MySQL Expression are up2date to the last rules.

in the ZIP com_sppagebuilder_pro_v5.0.0-rc.2.zip\admin\sql\updates\ there are lot of SQL Files with also that "old" definitons. These seems to me that these cannot be checked be cause of the old not updated way to use. Thats why I spoke about quick and dirty with the command set SQL_MODE = ''; So there is no "verfication" any more of the commands, e.g. the NOT Null, and so on, which you send for execution.

Hi,

I have problem uplading pictures:

https://prnt.sc/aNo7p1n7L4gh

https://prnt.sc/4bcRM1NQQh2o

So there seems to be a lot of work for Joomshaper.

Thx

Hello to team
yes sure i know you work hard for us.
Thx

Hi Jens,

thanks for supporting, hope I can get all the information that you need:

http://127.0.0.1/iggelheim-protestantisch/administrator/index.php?option=com_sppagebuilder&task=/editor.media

{"success":true,"message":null,"messages":null,"data":{"message":"Session mismatch."}}

https://prnt.sc/RWJNq3WeuhMi
https://prnt.sc/z7sa5JINMcgi

Best regards

Jürgen

Hi Jürgen,

thank you for the informations.
In this Screenshot, you should see the stack trace, if you scroll down in the tab "antwort".
-> https://prnt.sc/RWJNq3WeuhMi

Something like error, fatal error or exception.
When I am back at work tomorrow, I will check the sourcecode.

Have a nice evening.

An error has occurred.
0 Call to undefined function imagecreatefrompng()
Call stack
#   Function    Location
1   ()  JROOT\components\com_sppagebuilder\helpers\image.php:96
2   SppagebuilderHelperImage->createImageFromType() JROOT\components\com_sppagebuilder\helpers\image.php:31
3   SppagebuilderHelperImage->createThumb() JROOT\administrator\components\com_sppagebuilder\editor\traits\Media.php:253
4   SppagebuilderControllerEditor->uploadMedia()    JROOT\administrator\components\com_sppagebuilder\editor\traits\Media.php:51
5   SppagebuilderControllerEditor->media()  JROOT\libraries\src\MVC\Controller\BaseController.php:678
6   Joomla\CMS\MVC\Controller\BaseController->execute() JROOT\administrator\components\com_sppagebuilder\sppagebuilder.php:33
7   require_once()  JROOT\libraries\src\Dispatcher\LegacyComponentDispatcher.php:71
8   Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}()  JROOT\libraries\src\Dispatcher\LegacyComponentDispatcher.php:73
9   Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch() JROOT\libraries\src\Component\ComponentHelper.php:361
10  Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT\libraries\src\Application\AdministratorApplication.php:143
11  Joomla\CMS\Application\AdministratorApplication->dispatch() JROOT\libraries\src\Application\AdministratorApplication.php:186
12  Joomla\CMS\Application\AdministratorApplication->doExecute()    JROOT\libraries\src\Application\CMSApplication.php:293
13  Joomla\CMS\Application\CMSApplication->execute()    JROOT\administrator\includes\app.php:61
14  require_once()  JROOT\administrator\index.php:32

                </div>
                <section id="content" class="content">
                    <div id="system-message-container" aria-live="polite"></div>
                    <div class="row">
                        <div class="col-md-12">
                            <h1>An error has occurred.</h1>
                            <blockquote class="blockquote">
                                <span class="badge bg-secondary">0</span>
                                Call to undefined function imagecreatefrompng()                        
                            </blockquote>
                            <div>
                                <table class="table table-striped table-bordered">
                                    <tr>
                                        <td colspan="3">
                                            <strong>Call stack</strong>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            <strong>#</strong>
                                        </td>
                                        <td>
                                            <strong>Function</strong>
                                        </td>
                                        <td>
                                            <strong>Location</strong>
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>1        </td>
                                        <td>()        </td>
                                        <td>JROOT\components\com_sppagebuilder\helpers\image.php:96        </td>
                                    </tr>
                                    <tr>
                                        <td>2        </td>
                                        <td>SppagebuilderHelperImage->createImageFromType()        </td>
                                        <td>JROOT\components\com_sppagebuilder\helpers\image.php:31        </td>
                                    </tr>
                                    <tr>
                                        <td>3        </td>
                                        <td>SppagebuilderHelperImage->createThumb()        </td>
                                        <td>JROOT\administrator\components\com_sppagebuilder\editor\traits\Media.php:253        </td>
                                    </tr>
                                    <tr>
                                        <td>4        </td>
                                        <td>SppagebuilderControllerEditor->uploadMedia()        </td>
                                        <td>JROOT\administrator\components\com_sppagebuilder\editor\traits\Media.php:51        </td>
                                    </tr>
                                    <tr>
                                        <td>5        </td>
                                        <td>SppagebuilderControllerEditor->media()        </td>
                                        <td>JROOT\libraries\src\MVC\Controller\BaseController.php:678        </td>
                                    </tr>
                                    <tr>
                                        <td>6        </td>
                                        <td>Joomla\CMS\MVC\Controller\BaseController->execute()        </td>
                                        <td>JROOT\administrator\components\com_sppagebuilder\sppagebuilder.php:33        </td>
                                    </tr>
                                    <tr>
                                        <td>7        </td>
                                        <td>require_once()        </td>
                                        <td>JROOT\libraries\src\Dispatcher\LegacyComponentDispatcher.php:71        </td>
                                    </tr>
                                    <tr>
                                        <td>8        </td>
                                        <td>Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}()        </td>
                                        <td>JROOT\libraries\src\Dispatcher\LegacyComponentDispatcher.php:73        </td>
                                    </tr>
                                    <tr>
                                        <td>9        </td>
                                        <td>Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()        </td>
                                        <td>JROOT\libraries\src\Component\ComponentHelper.php:361        </td>
                                    </tr>
                                    <tr>
                                        <td>10        </td>
                                        <td>Joomla\CMS\Component\ComponentHelper::renderComponent()        </td>
                                        <td>JROOT\libraries\src\Application\AdministratorApplication.php:143        </td>
                                    </tr>
                                    <tr>
                                        <td>11        </td>
                                        <td>Joomla\CMS\Application\AdministratorApplication->dispatch()        </td>
                                        <td>JROOT\libraries\src\Application\AdministratorApplication.php:186        </td>
                                    </tr>
                                    <tr>
                                        <td>12        </td>
                                        <td>Joomla\CMS\Application\AdministratorApplication->doExecute()        </td>
                                        <td>JROOT\libraries\src\Application\CMSApplication.php:293        </td>
                                    </tr>
                                    <tr>
                                        <td>13        </td>
                                        <td>Joomla\CMS\Application\CMSApplication->execute()        </td>
                                        <td>JROOT\administrator\includes\app.php:61        </td>
                                    </tr>
                                    <tr>
                                        <td>14        </td>
                                        <td>require_once()        </td>
                                        <td>JROOT\administrator\index.php:32        </td>
                                    </tr>
                                </table>
                            </div>
                            <p>
                                <a href="/iggelheim-protestantisch/administrator" class="btn btn-secondary">
                                    <span class="icon-dashboard" aria-hidden="true"></span>
                                    Return to Dashboard
                                </a>
                            </p>
                        </div>
                    </div>
                </section>
            </div>

vendors.min.js:2     POST http://127.0.0.1/iggelheim-protestantisch/administrator/index.php?option=com_sppagebuilder&task=/editor.media 500 (Internal Server Error)
(anonym) @ vendors.min.js:2
xhr @ vendors.min.js:2
Se @ vendors.min.js:2
Promise.then (async)
request @ vendors.min.js:2
(anonym) @ vendors.min.js:2
(anonym) @ vendors.min.js:2
ie @ bundle.min.js:2
fn @ vendors.min.js:2
y @ vendors.min.js:2
c @ vendors.min.js:2
e @ vendors.min.js:2
execute @ vendors.min.js:2
await in execute (async)
mutate @ vendors.min.js:2
(anonym) @ bundle.min.js:2
s @ bundle.min.js:2
(anonym) @ bundle.min.js:2
(anonym) @ bundle.min.js:2
vt @ bundle.min.js:2
a @ bundle.min.js:2
(anonym) @ bundle.min.js:2
(anonym) @ bundle.min.js:2
(anonym) @ bundle.min.js:2
tl @ vendors.min.js:2
wu @ vendors.min.js:2
(anonym) @ vendors.min.js:2
bu @ vendors.min.js:2
su @ vendors.min.js:2
Bi @ vendors.min.js:2
lu @ vendors.min.js:2
Te @ vendors.min.js:2
Ur @ vendors.min.js:2
Kt @ vendors.min.js:2
$t @ vendors.min.js:2
bundle.min.js:2 Uncaught (in promise) TypeError: Cannot read properties of undefined (reading 'message')
    at bundle.min.js:2:752533
(anonym) @ bundle.min.js:2
Promise.then (async)
vt @ bundle.min.js:2
a @ bundle.min.js:2
(anonym) @ bundle.min.js:2
(anonym) @ bundle.min.js:2
(anonym) @ bundle.min.js:2
tl @ vendors.min.js:2
wu @ vendors.min.js:2
(anonym) @ vendors.min.js:2
bu @ vendors.min.js:2
su @ vendors.min.js:2
Bi @ vendors.min.js:2
lu @ vendors.min.js:2
Te @ vendors.min.js:2
Ur @ vendors.min.js:2
Kt @ vendors.min.js:2
$t @ vendors.min.js:2

There it is and thank you for the strack trace.

 Call to undefined function imagecreatefrompng()

The PHP-Extension "php-gd" is missing.
If the Extension is missing the function does not exists and will throw the error.
-> https://www.php.net/manual/de/function.imagecreatefrompng.php
-> https://www.php.net/manual/de/ref.image.php

Hi Jens,

thanks for fast and perfect support!
Edit PHP.ini

extension=gd

Now Upload works as a charme, with a green success message :)

No problem, would be great if joomshaper would also value my work/support.
It is what it is.
Or simply too much to ask.

I wish everyone a nice rest of the week and much success.

Hi Jens,

I agree with you. In that way Joomshaper has definitly to perform better in support cases.
In support cases Joomshaper must learn to ask more specific questions and help to analyze the problem. With your help Jens, I have been able to describe and filter many errors in detail. I expect the same from Joomshaper! The first answer to my problem was that I should reinstall everything and exactly this kind of support Joomshaper must learn to improve.
Thanks for the great interaction with you Jens, so troubleshooting is fun and I'm also willing to invest a lot of time in the search like you. Because this support is not self-evident from your side (Jens) as well as mine. I think I have spent a good 4 hours on Saturday to investigate the SQL problem and understandable for the support to document.
That PHP GD was not installed is "stupid" but also here Joomshaper could issue a "defined" error message that the customer has the chance to fix the error himself. With "PHP GD" not installed you can fix the error yourself.

Thanks for that cool support work and interaction!

@KawsharAhmed as already suggested, please have concrete messages displayed when, for example, debug mode is active.
How are you supposed to locate the problem with such a message?
Feel free to take another look at my proposal.

@bergwerk

• Activate the debug mode in the Joomla configuration.
• After that, please open the developer console with F12 and switch to the network there. "Option + ⌘ + J (on macOS)."
• Afterwards please call the backend of the pagebuilder where the error is displayed.
• In the developer console you should now find a red entry, where the status is 500.
• Click on this and then select the preview or response tab on the right.
• Here the stacktrace of the error should be visible. Most of the times, you need to scroll down and find the line where it says "error, fatal error or exception"

Simething like this:

                            <h1>An error has occurred.</h1>
                            <blockquote class="blockquote">
                                <span class="badge bg-secondary">0</span>
                                Call to undefined function imagecreatefrompng()                        
                            </blockquote>

With the information it should then be possible to find out the cause.

Have a nice day.

Hi Jens,

thanks for your answer - i did activate debug mode of course, but since the error occurs in async requests it is not showing in the console.
I did some more digging however and this one is also related to the "content" field not existing as mentioned in another reply (1054 Unknown column 'content' in 'field list' ).

I guess the update script of RC2 sometimes fails because the date/time format default values (0000-00-00 00:00:00) are not valid on some mySQL intances.

Hi bergwerk,

i assume from your name that you speak German.
I would write it therefore just briefly in German, which is more understandable.

Das ist richtig, dass es in der Konsole nicht zu sehen ist, wenn Sie im Netzwerk der Konsole auf den roten Eintrag klicken, so wie in Ihrem Screenshot zu sehen, dann finden Sie in der Registerkarte "Antwort bzw. Response" die Fehlermeldung den der Async-Request ausgelöst hat. :)

English:
That is correct that it is not visible in the console, if you click on the red entry in the network of the console, as you can see in your screenshot, then you will find in the tab "Response" the error message that the async request has triggered.

I guess the update script of RC2 sometimes fails because the date/time format default values (0000-00-00 00:00:00) are not valid on some mySQL intances.

This is quite possible, this was what I could find out with the help of Jürgen and his quickfix.
https://www.joomshaper.com/forum/question/25335#qa-answer-119019
https://www.joomshaper.com/forum/question/25335#qa-answer-118982

Have a nice day. :)