Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
3.1.4
-
None
-
I use AWS EC2 with Ubuntu 14.04 64Bit + phpBB3.1.4
$ sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y dist-upgrade && sudo apt-get -y autoremove
$ sudo apt-get -y install zip unzip mysql-client-5.6 mysql-client-core-5.6 mysql-common-5.6 php5-mysql php5-curl php5-gd php5-imap php5-ldap php5-odbc php-pear php-xml-parser php-xml-rpc php5-mcrypt libmcrypt-dev
$ sudo updatedb && sudo php5enmod mcrypt
$ sudo chmod 777 /var/www/html
$ cd /var/www/html/
$ wget https://www.phpbb.com/files/release/phpBB-3.1.4.tar.bz2
$ tar -xvf phpBB-3.1.4.tar.bz2
$ sudo chmod 777 phpBB3/config.php phpBB3/cache/ phpBB3/files/ phpBB3/store/ phpBB3/images/avatars/upload/
$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 14.04.2 LTS
Release: 14.04
Codename: trusty
$ php -v
PHP 5.5.9-1ubuntu4.9 (cli) (built: Apr 17 2015 11:44:57)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies
with Zend OPcache v7.0.3, Copyright (c) 1999-2014, by Zend TechnologiesI use AWS EC2 with Ubuntu 14.04 64Bit + phpBB3.1.4 $ sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y dist-upgrade && sudo apt-get -y autoremove $ sudo apt-get -y install zip unzip mysql-client-5.6 mysql-client-core-5.6 mysql-common-5.6 php5-mysql php5-curl php5-gd php5-imap php5-ldap php5-odbc php-pear php-xml-parser php-xml-rpc php5-mcrypt libmcrypt-dev $ sudo updatedb && sudo php5enmod mcrypt $ sudo chmod 777 /var/www/html $ cd /var/www/html/ $ wget https://www.phpbb.com/files/release/phpBB-3.1.4.tar.bz2 $ tar -xvf phpBB-3.1.4.tar.bz2 $ sudo chmod 777 phpBB3/config.php phpBB3/cache/ phpBB3/files/ phpBB3/store/ phpBB3/images/avatars/upload/ $ lsb_release -a No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 14.04.2 LTS Release: 14.04 Codename: trusty $ php -v PHP 5.5.9-1ubuntu4.9 (cli) (built: Apr 17 2015 11:44:57) Copyright (c) 1997-2014 The PHP Group Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies with Zend OPcache v7.0.3, Copyright (c) 1999-2014, by Zend Technologies
Description
After phpBB3 installed, I got the error message:
SQL ERROR [ mysqli ]
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 '' at line 3 [1064]
SQL
SELECT * FROM phpbb_styles s WHERE s.style_id =
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/phpbb/user.php
LINE: 238
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/index.php
LINE: 29
CALL: phpbb\user->setup()
I made a simple patch taking a try to get a style for default usage.
