cloudy cloudy

Author Topic: Euroblitz  (Read 551 times)

0 Members and 1 Guest are viewing this topic.

Offline staccermaccer

  • Posts: 218
  • Antwerp,Belgium
  • OS/Browser:
  • Win NT 10.0
  • Chrome 64.0.3282.140
    • Weather in Ekeren and Harbour of Antwerp
Euroblitz
« on: January 24, 2019, 08:26:02 PM »
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,

Offline CQCQDX

  • Posts: 74
  • Woerden
  • OS/Browser:
  • Win 7/Srvr 2008R2
  • Mozilla compatible
    • weerstation-woerden
Re: Euroblitz
« Reply #1 on: January 25, 2019, 09:22:50 PM »
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 

Offline staccermaccer

  • Posts: 218
  • Antwerp,Belgium
  • OS/Browser:
  • Win NT 10.0
  • Chrome 64.0.3282.140
    • Weather in Ekeren and Harbour of Antwerp
Re: Euroblitz
« Reply #2 on: January 26, 2019, 01:20:18 PM »
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,

Offline staccermaccer

  • Posts: 218
  • Antwerp,Belgium
  • OS/Browser:
  • Win NT 10.0
  • Chrome 64.0.3282.140
    • Weather in Ekeren and Harbour of Antwerp
Re: Euroblitz
« Reply #3 on: February 17, 2019, 05:39:28 PM »
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:
Quote
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  :D <-- this one is not!

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

Staccermaccer,

Offline niko

  • syzygy
  • Global Moderator
  • Posts: 28,172
  • Crystal Ball broken! Please post the URL.
  • Northern California, U.S.A.
  • OS/Browser:
  • Win 7/Srvr 2008R2
  • Chrome 72.0.3626.109
Re: Euroblitz
« Reply #4 on: February 17, 2019, 07:10:18 PM »
Use the Code # button instead of quote to avoid unwanted smilies  :wink: 

Code: [Select]
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).