phpBB • Free and Open Source Forum Software

Code: Select all

[phpBB Debug] PHP Notice: in file [ROOT]/phpbb/db/tools/tools.php on line 1181: Undefined index: i
Return to the index page
General Error
SQL ERROR [ mysqli ]

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 'DEFAULT 'u' NOT NULL' at line 1 [1064]

SQL

ALTER TABLE `phpbb_users` ADD COLUMN `0` DEFAULT 'u' NOT NULL

Code: Select all

SQL

ALTER TABLE `phpbb_users` ADD COLUMN `0` DEFAULT 'u' NOT NULL

Code: Select all

[Sat Jun 29 04:11:20.757785 2024] [proxy_fcgi:error] [pid 24380:tid 140413587404544] [client 2a02:1812:1e10:400:ad77:3d4c:36dc:bf7a:0] AH01071: Got error 'PHP message: PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 132120776 bytes) in /var/www/vhosts/myarea51secrets.com/httpdocs/phpbb/db/driver/driver.php on line 1112', referer: https://www.myarea51secrets.com/adm/index.php?i=acp_extensions&sid=52cef75dae5d1a7acaff498c65cc8cd2&mode=main&action=enable_pre&ext_name=andreask%2Fium

Code: Select all

'ium_request_type'

Code: Select all

'ium_request_type'=> array('VCHAR:10', ''),

Code: Select all

<?php

/**
* This file is part of the phpBB Forum extension package
* IUM (Inactive User Manager).
*
* @copyright (c) 2016 by Andreas Kourtidis
* @license   GNU General Public License, version 2 (GPL-2.0)
*
* For full copyright and license information, please see
* the CREDITS.txt file.
*/

namespace andreask\ium\migrations;

use phpbb\db\migration\migration;

/**
 * Add needed data to database of phpbb
 */

class update_120 extends migration
{

	public function update_data()
	{
		return array(
			array('config.add', array('andreask_ium_interval2', 0)),
			array('config.add', array('andreask_ium_interval3', 0)),
			array('config.add', array('andreask_ium_respect_user_choice', 1)),
			array('config.add', array('andreask_ium_ignore_limit', 1)),
			array('config.add', array('andreask_ium_no_reply', '')),
			array('config.remove', array('reminder_limit')),
		);
	}

  static public function depends_on()
  {
	  return ['andreask\ium\migrations\add_data'];
  }

  public function update_schema()
  {
	return [
		'drop_columns' =>[
			$this->table_prefix . 'users'=>
			['ium_request_type',],
		],
	];
  }

	public function revert_schema()
	{
		return array(
			'add_columns' => array(
				$this->table_prefix . 'users' => array(
					'ium_request_type'=> array('VCHAR:10', ''),
				),
			),
		);
	}
}