Posts: 4
Threads: 1
Joined: 2015-05-15
Dear all,
during he new installtion of my page I always get the message:
"Error:
at
INSERT IGNORE INTO bo_user SET id=1, login='', password='', level=1, mail=''
Some errors occured! Please check if the tables exists."
Can someone give me a hint, I checked all setting in config.php an I have absolutley no idea what the origin of this message is.
Kind regards
Thomas
Posts: 296
Threads: 9
Joined: 2014-07-21
did you create the database ?
Posts: 4
Threads: 1
Joined: 2015-05-15
(2015-05-17, 08:50)Eric.Wouters Wrote: did you create the database ?
Eric,
thank you for your reply. Something happend... but still 1022.64 of 1024 MB are free.
But I doubt the the complete database is so small
Best regards
Thomas
Posts: 296
Threads: 9
Joined: 2014-07-21
an empty database (with tables pre configured) isn't big at all
but guess something is wrong
since this is a new install, just kill it and make a new one. Nothing you loose.
be sure to use the correct details in config file to connect to database. Some hosters user prefix in names (cpanel for exemple uses accountname_dbname etc)
Posts: 4
Threads: 1
Joined: 2015-05-15
(2015-05-17, 09:14)Eric.Wouters Wrote: an empty database (with tables pre configured) isn't big at all
but guess something is wrong
since this is a new install, just kill it and make a new one. Nothing you loose.
be sure to use the correct details in config file to connect to database. Some hosters user prefix in names (cpanel for exemple uses accountname_dbname etc)
Eric,
I deleted the database and started again. It seems that I got one step further. But I get the following report:
Strict Standards: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CEST/2.0/DST' instead in /homepages/8/d482373604/htdocs/Blitz/includes/templates_gmap.inc.php on line 164
Strict Standards: strtotime(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CEST/2.0/DST' instead in /homepages/8/d482373604/htdocs/Blitz/includes/templates_gmap.inc.php on line 165
Strict Standards: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CEST/2.0/DST' instead in /homepages/8/d482373604/htdocs/Blitz/includes/templates_gmap.inc.php on line 172
Strict Standards: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CEST/2.0/DST' instead in /homepages/8/d482373604/htdocs/Blitz/includes/templates_gmap.inc.php on line 180
Strict Standards: date(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Berlin' for 'CEST/2.0/DST' instead in /homepages/8/d482373604/htdocs/Blitz/includes/templates.inc.php on line 520
2015-05-17 11:52:12 + 0ms | 2015-05-17 11:52:12 + 0ms | ***** Getting lightning data from blitzortung.org ***** 2015-05-17 11:52:12 + 0ms | 2015-05-17 11:52:12 + 14ms | Information: PHP Execution timeout is 50000s --> Fine *** Setting MyBlitzortung timeout to: 55s 2015-05-17 11:52:12 + 16ms | Waiting 20 seconds, to avoid too high load on Blitzortung servers ... 2015-05-17 11:52:12 +20018ms | 2015-05-17 11:52:12 +20018ms | === Strikes === 2015-05-17 11:52:12 +20050ms | Last strike: 2015-05-17 11:49:14 *** Loading 2 files from 2015-05-17 11:40:00 to 2015-05-17 11:50:00 *** This is update #5 2015-05-17 11:52:12 +20145ms | Downloading file /2015/05/17/11/40.log, last modified 2015-05-17 11:44:12, last position 92414 bytes: OK 2015-05-17 11:52:12 +20148ms | Found latest strike from last import 2015-05-17 11:52:12 +20314ms | Downloading file /2015/05/17/11/50.log: OK 2015-05-17 11:52:12 +20599ms | Lines: 274 *** Size: 132kB *** New Strikes: 80 2015-05-17 11:52:12 +20656ms | 2015-05-17 11:52:12 +20656ms | === Stations === 2015-05-17 11:52:12 +20769ms | Last update: 2015-05-17 11:37:38 *** This is update #1 2015-05-17 11:52:12 +22014ms | Stations: 1065 *** New Stations: 0 *** Updated: 616 *** No Update: 450 2015-05-17 11:52:12 +22089ms | 2015-05-17 11:52:12 +22089ms | === Raw-Data === 2015-05-17 11:52:12 +22089ms | Not implemented! 2015-05-17 11:52:12 +22093ms | 2015-05-17 11:52:12 +22093ms | === Strike alerts === 2015-05-17 11:52:12 +22097ms | No alerts sent. 2015-05-17 11:52:12 +22104ms | 2015-05-17 11:52:12 +22104ms | Import finished. Exiting... 2015-05-17 11:52:12 +22104ms |
I wonder why the scripts complains about the time setting ... ??? Time setting in config.php is UTC.
Kind regards
Thomas
Posts: 296
Threads: 9
Joined: 2014-07-21
mmm not to sure but feels like server time is offset to what is needed by the script though I'm not a coder
maybe a coder can give more details
but at least your database is working and it did loads data
in my config I set as follows
//Your timezone
define("BO_TIMEZONE", "Europe/Paris");
Posts: 4
Threads: 1
Joined: 2015-05-15
(2015-05-17, 12:02)Eric.Wouters Wrote: mmm not to sure but feels like server time is offset to what is needed by the script though I'm not a coder
maybe a coder can give more details
but at least your database is working and it did loads data
in my config I set as follows
//Your timezone
define("BO_TIMEZONE", "Europe/Paris");
Dear Eric,
tried to change it to Europe/Paris. The the system complained it needs "Europe/Berlin"....
In the moment I give up....maybe I give it another try tomorrow.
73
Thomas
Posts: 1
Threads: 0
Joined: 2017-12-28
I have the same problem- do have someone an idea ? Thank you !