[Dxspider-support] Assistance with Setup

[Michael Serowik]

MariaDB [dxcluster]> CREATE TABLE 'spot' ( 'rowid' int(11) NOT NULL AUTO_INCREMENT, 'freq' double NOT NULL, 'spotcall' varchar(14) NOT NULL, 'time' int(11) NOT NULL, 'comment' varchar(255) DEFAULT NULL, 'spotter' varchar(14) NOT NULL, 'spotdxcc' smallint(6) DEFAULT NULL, 'spotterdxcc' smallint(6) DEFAULT NULL, 'origin' varchar(14) DEFAULT NULL, 'spotitu' tinyint(4) DEFAULT NULL, 'spotcq' tinyint(4) DEFAULT NULL, 'spotteritu' tinyint(4) DEFAULT NULL, 'spottercq' tinyint(4) DEFAULT NULL, 'spotstate' char(2) DEFAULT NULL, 'spotterstate' char(2) DEFAULT NULL, 'ipaddr' varchar(40) DEFAULT NULL, PRIMARY KEY ('rowid'), KEY 'spot_ix1' ('time'), KEY 'spot_ix2' ('spotcall'), KEY 'spiderweb_spotter' ('spotter') ) ENGINE=InnoDB AUTO_INCREMENT=2598318 DEFAULT CHARSET=utf8mb4

    -> ;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''spot' ( 'rowid' int(11) NOT NULL AUTO_INCREMENT, 'freq' 

double NOT NULL, 'sp...' at line 1

 

 

So a quick google on the message provide me with this result.

 

The issue with your SQL syntax is that MariaDB (and MySQL) expects table and column names to be enclosed in backticks (`) rather than single quotes ('). To fix the syntax error, you need to replace the single quotes around the table name and column names with backticks.

 

Not sure what any of this means.

 

 

Mike – N3BSQ

 

 

 

 

From: Dxspider-support <dxspider-support-bounces at tobit.co.uk> On Behalf Of Danilo Brelih via Dxspider-support
Sent: Thursday, October 10, 2024 12:46 PM
To: Michael Serowik via Dxspider-support <dxspider-support at tobit.co.uk>
Cc: Danilo Brelih <s50u at s50e.si>
Subject: Re: [Dxspider-support] Assistance with Setup

 

Michael Serowik via Dxspider-support je 10.10.2024 ob 16:53 napisal:

Sorry for long post but wanted to give as much information as I can.

Have you tried to create database manually?

- as sysop (not root !) create the database. From mysql console: CREATE DATABASE dxcluster;

- give the right privileges to the user you are using for dxspider. For example: GRANT ALL PRIVILEGES ON dxcluster.* to 'sysop'@'localhost';

- create spot table with following command: 

CREATE TABLE 'spot' ( 'rowid' int(11) NOT NULL AUTO_INCREMENT, 'freq' double NOT NULL, 'spotcall' varchar(14) NOT NULL, 'time' int(11) NOT NULL, 'comment' varchar(255) DEFAULT NULL, 'spotter' varchar(14) NOT NULL, 'spotdxcc' smallint(6) DEFAULT NULL, 'spotterdxcc' smallint(6) DEFAULT NULL, 'origin' varchar(14) DEFAULT NULL, 'spotitu' tinyint(4) DEFAULT NULL, 'spotcq' tinyint(4) DEFAULT NULL, 'spotteritu' tinyint(4) DEFAULT NULL, 'spottercq' tinyint(4) DEFAULT NULL, 'spotstate' char(2) DEFAULT NULL, 'spotterstate' char(2) DEFAULT NULL, 'ipaddr' varchar(40) DEFAULT NULL, PRIMARY KEY ('rowid'), KEY 'spot_ix1' ('time'), KEY 'spot_ix2' ('spotcall'), KEY 'spiderweb_spotter' ('spotter') ) ENGINE=InnoDB AUTO_INCREMENT=2598318 DEFAULT CHARSET=utf8mb4

- reboot your system

73, Dan S50U

-- 
S50CLX DX Cluster <https://s50clx.infrax.si> 



-- 
This email has been checked for viruses by Avast antivirus software.
www.avast.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.tobit.co.uk/pipermail/dxspider-support/attachments/20241010/fcb1f8da/attachment.htm>