Page 1 of 1

Cannot import SQL Journal DEMO5 dark theme

Posted: Wed Oct 05, 2022 5:22 am
by thehazzard
Hi all,

i am wondering who i need to contact. I have ordered the JOURNAL3 template years ago.
I want now to use it. But when i want to import DEMO5 dark, and try to import the sql database, i get an error message.

(Warning the uploaded file exceeds the upload_max_filesize directive in php.ini.

but when i look in to my php.ini file it should be fine.

Code: Select all

magic_quotes_gpc = Off 
register_globals = Off 
default_charset = UTF-8 
memory_limit = 64M 
max_execution_time = 36000 
upload_max_filesize = 999999M ——this one, it was 999. but i changed it this., 
safe_mode = Off 
mysql.connect_timeout = 20 
session.auto_start = Off 
session.use_only_cookies = On 
session.use_cookies = On 
session.use_trans_sid = Off 
session.cookie_httponly = On 
session.gc_maxlifetime = 3600 
allow_url_fopen = On ;
display_errors = 1 ;
error_reporting = E_ALL
The sql file it self is about 6900 so it should be enough….

but the creators of JOURNAL saying this is something with my hosting provider, is that true??

Re: Cannot import SQL Journal DEMO5 dark theme

Posted: Wed Oct 05, 2022 4:29 pm
by ADD Creative
Yes, ask you host how you can change upload_max_filesize. It not always set in the local php.ini.

You can use phpinfo() to check what the value is.
https://www.php.net/manual/en/function.phpinfo.php

Re: Cannot import SQL Journal DEMO5 dark theme

Posted: Wed Oct 05, 2022 7:54 pm
by paulfeakins
djoeksanovic wrote:
Wed Oct 05, 2022 5:22 am
but the creators of JOURNAL saying this is something with my hosting provider, is that true??
Well they should be able to give you the question to send to your hosting provider ...

Re: Cannot import SQL Journal DEMO5 dark theme

Posted: Wed Oct 05, 2022 8:39 pm
by JNeuhoff
In addition to increasing the upload_max_filesize setting, it's always a good idea to use a standard-compliant web theme, and not the Journal3 framework. The latter is not supported on this forum which is for OpenCart only.

Re: Cannot import SQL Journal DEMO5 dark theme

Posted: Fri Oct 07, 2022 10:29 am
by Joe1234
Shot in the dark, but just increase everything to the max. And if it doesn't work it is definitely a host thing. I went to war with mine over something they were blaming on OC which didn't make sense. Had to call back 5 times to get it fixed by someone competent.

Re: Cannot import SQL Journal DEMO5 dark theme

Posted: Fri Oct 07, 2022 5:19 pm
by paulfeakins
Joe1234 wrote:
Fri Oct 07, 2022 10:29 am
Shot in the dark, but just increase everything to the max.
When it's free text like in the above text file, how do you know what the max is? Also sometimes if you set a limit over the maximum it just won't work at all.

Joe1234 wrote:
Fri Oct 07, 2022 10:29 am
And if it doesn't work it is definitely a host thing.
No that doesn't follow necessarily, although it probably is.

Joe1234 wrote:
Fri Oct 07, 2022 10:29 am
I went to war with mine over something they were blaming on OC which didn't make sense. Had to call back 5 times to get it fixed by someone competent.
Hosts always try and blame the code until you can prove it's them.

Re: Cannot import SQL Journal DEMO5 dark theme

Posted: Tue Oct 18, 2022 11:03 pm
by thehazzard
can be solved, indeed with the hosting.

In directAdmin you can change it yourself...

Step 1
After logging in, select a domain name that you previously added.
Then scroll down a bit until you arrive at Advanced Features.
Step 2
Then click on Select PHP version.

Image
Step 3: Select the desired PHP version
When you have done that you will immediately be given the option to change the PHP version. You click on the current PHP version, 7.0 in this case. You will see a dropdown menu with the available versions, you select the version you want to use.

Image
Once you have chosen a version, click Set as current

Image

Image
You will now be taken to a new screen that looks something like the image below.

Image
Step 4a
Now suppose we want to change the post_max_size setting, how do we do that? First, click on the current value for that setting. This is shown in blue, 8M in the picture.

Image
Step 4b
You click on the value and then a dropdown menu will appear where you can choose the new value for that setting, see image below. You now sound the desired value, it stores itself!

Image

You will then see a pop-up appear in the top right. This means it was successful and the change is active!
Image