search

scrollmapper / bible_databases

Bible versions and cross-reference databases.
977 stars 346 forks source link

The current version of bible-mysql.sql has issues #40

Closed karljboer closed 3 years ago

karljboer commented 4 years ago

Hello, The current version of bible-mysql.sql has issues importing in the bible_databases-master folder. Problem may exist in other locations. I've tried it on two different platforms with the same issues:

Error

Static analysis:

2 errors were found during analysis.

1. Unexpected beginning of statement. (near "phpMyAdmin" at position 0)
2. Unrecognized statement type. (near "SQL" at position 11)

SQL query:

phpMyAdmin SQL Dump -- version 4.1.14 -- http://www.phpmyadmin.net -- -- Host: 127.0.0.1 -- Generation Time: Feb 09, 2016 at 01:36 AM -- Server version: 5.6.17 -- PHP Version: 5.5.12 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"

MySQL said: Documentation

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'phpMyAdmin SQL Dump

-- version 4.1.14 -- http://www.phpmyadmin.net

-- Host: ' at line 1

karljboer commented 4 years ago

After working around this, I now have the new version live on randombible.org. Thanks to all who have participated in this project!!