Euroblitz

Hi, all

Is there someone out there who can help me with this: my server recently upgraded to PHP7.1, so now my EB script is not working anymore like it should be,

I do not see graphs on my “euroblitz”-script, which draws the “fmi” graphic (?) but not the “BO” and the “station”…

I hope it’s something that can be solved because i am breaking my head about this for a month now, been searching the forum “stackoverflow” which is very interesting if you are humble coder like me…

Thanks in advance,

Staccermaccer,


fmi.png

looks like your database is not working ok
if you look into yours bo.json ( be) file you will see that you are missing many lines
if you look into my bo.json ( nl) you will see all the lines you need

try to copy my txt into your bo.json file and look if the graphs are working for test

hope this will help
greetings


bo.json.be.txt (536 Bytes)

bo.json.nl.txt (6 KB)

Hi,

That is indeed a great difference! I know my bo_update is working but the transition to PHP7.1 does not seem to work. So i must adapt the SQL to work with MySQLi.

Have to solve that first!

Staccermaccer,

Hi, all!

I can’t get the sql-script to work with my version of PHP/MYSQLI PHP version is 7.1 and the db-engine is MARIADB. I have tried so far to convert it with DB browser for sqlite, DB-fiddler,Yak, and some more tools. But none of these work, they Always come up with the same message:

CREATE TABLE IF NOT EXISTS bo_hourly (
time INTEGER(15) NOT NULL,
strikes INTEGER(6) NOT NULL,
st_strikes INTEGER(8) NOT NULL,
UNIQUE KEY time (time)
);# MySQL returned an empty result set (i.e. zero rows).

CREATE TABLE IF NOT EXISTS bo_stat (
date date NOT NULL,
strikes mediumint(11) unsigned NOT NULL DEFAULT ‘0’,
maxdist INTEGER(6) NOT NULL DEFAULT ‘0’,
mindist int(6) NOT NULL DEFAULT ‘999999’,
maxstrikes mediumint(11) unsigned NOT NULL DEFAULT ‘0’,
maxtime INTEGER(15) unsigned NOT NULL DEFAULT ‘0’,
maxusers INTEGER(6) NOT NULL DEFAULT ‘0’,
st_strikes INTEGER(8) NOT NULL,
st_mindist INTEGER(6) NOT NULL DEFAULT ‘999999’,
st_maxdist INTEGER(6) NOT NULL DEFAULT ‘0’,
st_max INTEGER(6) NOT NULL,
st_maxtime INTEGER(15) NOT NULL,
KEY time (date)
);# MySQL returned an empty result set (i.e. zero rows).

Is there somebody who can help me with this?

The smileys are produced by the semicolons :smiley: ← this one is not!

Hope that there is someone out there ho can finally help me to solve this…

Staccermaccer,

Use the Code # button instead of quote to avoid unwanted smilies :wink:

CREATE TABLE IF NOT EXISTS `bo_hourly` (
  `time` INTEGER(15) NOT NULL,
  `strikes` INTEGER(6) NOT NULL,
  `st_strikes` INTEGER(8) NOT NULL,
  UNIQUE KEY `time` (`time`)
);# MySQL returned an empty result set (i.e. zero rows).


CREATE TABLE IF NOT EXISTS `bo_stat` (
  `date` date NOT NULL,
  `strikes` mediumint(11) unsigned NOT NULL DEFAULT '0',
  `maxdist` INTEGER(6) NOT NULL DEFAULT '0',
  `mindist` int(6) NOT NULL DEFAULT '999999',
  `maxstrikes` mediumint(11) unsigned NOT NULL DEFAULT '0',
  `maxtime` INTEGER(15) unsigned NOT NULL DEFAULT '0',
  `maxusers` INTEGER(6) NOT NULL DEFAULT '0',
  `st_strikes` INTEGER(8) NOT NULL,
  `st_mindist` INTEGER(6) NOT NULL DEFAULT '999999',
  `st_maxdist` INTEGER(6) NOT NULL DEFAULT '0',
  `st_max` INTEGER(6) NOT NULL,
  `st_maxtime` INTEGER(15) NOT NULL,
  KEY `time` (`date`)
);# MySQL returned an empty result set (i.e. zero rows).