Topic: MeteoBridge to MySQL Database Error. **solved**

[Bahni]

Hi,
I've tried it once, it doesn't work yet.
The connection to the MyQSL server works, there is a green tick on it.
I did everything according to the description and successfully imported the prefabricated "meteobridge.sql" file with phpMyAdmin.
I get the following error message at Meteobridge:

Code: [Select]

2021-02-14 14:04:00 Error: 2021-02-14 14:04:00 MYSQL query 'INSERT INTO `lakewebster` (`ID`, `DateTime`, `TempOutCur`, `HumOutCur`, `PressCur`, `DewCur`, `HeatIdxCur`, `WindChillCur`, `TempInCur`, `HumInCur`, `WindSpeedCur`, `WindAvgSpeedCur`, `WindDirCur`, `WindDirCurEng`, `WindGust10`, `WindDirAvg10`, `WindDirAvg10Eng`, `RainRateCur`, `RainDay`, `RainYest`, `RainMonth`, `RainYear`) VALUES (NULL, '2021-02-14 14:04:00', '30.0', '60.0', '30.70', '17.8', '30.0', '28.2', '69.6', '40.0', '2.2', '1.3', '104.0', 'ESE', '2.2', '113.0', 'ESE', '0.00', '0.01', '0.00', '0.57', '1.98')' failed: Table 'meteobridge.lakewebster' doesn't exist (no more tries):

[Gyvate]

Hi,
I've tried it once, it doesn't work yet.
The connection to the MyQSL server works, there is a green tick on it.
I did everything according to the description and successfully imported the prefabricated "meteobridge.sql" file with phpMyAdmin.
I get the following error message at Meteobridge:

Code: [Select]

2021-02-14 14:04:00 Error: 2021-02-14 14:04:00 MYSQL query 'INSERT INTO `lakewebster` (`ID`, `DateTime`, `TempOutCur`, `HumOutCur`, `PressCur`, `DewCur`, `HeatIdxCur`, `WindChillCur`, `TempInCur`, `HumInCur`, `WindSpeedCur`, `WindAvgSpeedCur`, `WindDirCur`, `WindDirCurEng`, `WindGust10`, `WindDirAvg10`, `WindDirAvg10Eng`, `RainRateCur`, `RainDay`, `RainYest`, `RainMonth`, `RainYear`) VALUES (NULL, '2021-02-14 14:04:00', '30.0', '60.0', '30.70', '17.8', '30.0', '28.2', '69.6', '40.0', '2.2', '1.3', '104.0', 'ESE', '2.2', '113.0', 'ESE', '0.00', '0.01', '0.00', '0.57', '1.98')' failed: Table 'meteobridge.lakewebster' doesn't exist (no more tries):

Searching helps .... 
if you enter "meteobridge lakewebster" in Google, you are directed to an article in this forum:
https://www.wxforum.net/index.php?topic=25264.0
That's most likely the solution of the above error.

[Bahni]

Hello and thanks!
It works now.
In the event definition of Meteobridge you don't have to enter "Lakewebster" as in the description, but rather "mystation" as Steve called it in his "meteobridge.sql".