Dotnetpanel Forums

I've created a Application Pack phpBB 3.0.0, this should work fine I've done a bit of testing and it seems to be OK

http://forum.dotnetpanel.com/files/folders/application_installer_packs_220_above/entry18905.aspx

Minimum Requirements

phpBB3 has a few requirements which must be met before you are able to install and use it.

• A webserver or web hosting account running on any major Operating System with support for PHP
• A SQL database system, one of:
  
• MySQL 3.23 or above (MySQLi supported)
  
• PHP 4.3.3+ (>=4.3.3, >4.4.x, >5.x.x, >6.0-dev (compatible)) with support for the database you intend to use.
• getimagesize() function need to be enabled
• These optional presence of the following modules within PHP will provide access to additional features, but they are not required.
  
  • zlib Compression support
  • Remote FTP support
  • XML support
  • Imagemagick support
  • GD Support

Thanks!

Just setup the phpBB3 pack, but seem to have problems installing it.

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'INSTALL_APPLICATION' task on 'phpBB 3.0.0' APP_INSTALLER ---> System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> MySql.Data.MySqlClient.MySqlException: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' '', 0, 1201869910, 0, '', '', 0, 0, 0, 0, 0, 0, 1, 'en', 0.00, 0, 'D M d, Y g:i' at line 7
at MySql.Data.MySqlClient.PacketReader.CheckForError()
at MySql.Data.MySqlClient.PacketReader.ReadHeader()
at MySql.Data.MySqlClient.PacketReader.OpenPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst)
at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[ bytes, Int32 length, Boolean consume)
at MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader)
at MySql.Data.MySqlClient.MySqlCommand.Consume()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at DotNetPanel.Providers.Database.MySqlServer.ExecuteSqlNonQuerySafe(String databaseName, String username, String password, String commandText)
at DotNetPanel.Server.DatabaseServer.ExecuteSqlNonQuerySafe(String databaseName, String username, String password, String commandText)
--- End of inner exception stack trace ---
at DotNetPanel.EnterpriseServer.WebApplicationsInstaller.RunScenario(String scenarioPath, InstallationInfo inst, Boolean throwExceptions)
at DotNetPanel.EnterpriseServer.WebApplicationsInstaller.InstallWebApplication(InstallationInfo inst)
--- End of inner exception stack trace ---
at DotNetPanel.EnterpriseServer.WebApplicationsInstaller.InstallWebApplication(InstallationInfo inst)
at DotNetPanel.EnterpriseServer.WebApplicationsInstaller.InstallApplication(InstallationInfo inst)
at DotNetPanel.EnterpriseServer.esApplicationsInstaller.InstallApplication(InstallationInfo inst)
--- End of inner exception stack trace ---
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[ parameters)
at DotNetPanel.EnterpriseServer.esApplicationsInstaller.InstallApplication(InstallationInfo inst)
at DotNetPanel.Portal.InstallerInstallApplication.InstallApplication()  

It does copy the files in the home directory, but fails to create the MySQL DB. When I first create a DB it creates the tables but does not seem to finish completely. So it seems it has got something to do with the SQL syntax.

When I just download phpBB3 from phpbb.com and install it manually it works fine.

Using DNP 2.3.0, PHP 5.2.3 and MySQL 5.0.27

Funny seems to be working ok here, MySQL 5.0.45 and DNP 2.3.1

directhostinguk:

Funny seems to be working ok here, MySQL 5.0.45 and DNP 2.3.1

I am a bit puzzled about this one. This time I have been playing around with this on our test server which has the latest versions of PHP, MySQL and DNP.

Still get the same error.

Now, when I let the application installer handle the creation of the DB, it doesn't even create the DB. It only copies the phpBB files to the hosting space and then produces the same error. When I create the DB manually in advance it seems to dump a lot of tables and content in the DB but still it fails to install completely.

Can you please explain where the creation of the DB is handled? I couldn't find it in the two SQL files. Nor in the ascx file.

Also, manual installation of phpBB3 on both production and test server works fine. So there shouldn't be anything in my MySQL and PHP configs which is incompatible with phpBB3.

Not sure what to say, it seems to be fine here, installed it a few times today to make sure and it's working fine.

Hi Graham,

I am updating the package to the lastest version. One question though, is there a specific reason why you split the .sql script in two (one for the schema and one for the data)?

Ingvald:

Hi Graham,

I am updating the package to the lastest version. One question though, is there a specific reason why you split the .sql script in two (one for the schema and one for the data)?

Not really just decided it was better to have two small files than one big file, it's the same with the Joomla