منتديات phpBBArabia

كود: تحديد الكل

I was having the same problem; after panicking and searching this forum and the web, I found solution by turning on debug options and manually inspecting the tables. It turns out that I gave SELECT, INSERT, UPDATE privileges to dbuser but no ALTER and other privileges it needs to update the database. So install/database_update.php was telling me that it has updated the Database but it was only able to modify the version number.

كود: تحديد الكل

????? ????? ???????? ??? ??? ?????

??? ????? ???????? :: mysql4
??????? ?????? :: 3.0.2
????? ??????? :: 3.0.4


????? ??????? ????? ????????

?????? :: . . . . . . . . . . . . . . . ?????
??????? :: ?? ?????


????? ????????

?????? :: . . . . ?????
??????? :: ?? ?????


????? ??????? ??????? ???????

?????? :: . . ?????
??????? :: ?? ?????

????? ???????

كود: تحديد الكل

SQL ERROR [ mysql4 ]

Data too long for column 'config_value' at row 1 [1406]

SQL

INSERT INTO phpbb_gym_config (config_name, config_value, config_type) VALUES ('rss_forum_c_info', '????? ????? ???? ????? ?????? ???? ????? ??????? ??? ???? ???? ?????', 'rss')

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: gym_sitemaps/includes/gym_common.php
LINE: 81
CALL: dbal_mysql->sql_query()

FILE: gym_sitemaps/gym_install.php
LINE: 486
CALL: set_gym_config()

FILE: gym_sitemaps/gym_install.php
LINE: 172
CALL: install_gym_sitemaps->main()

FILE: gym_sitemaps/gym_install.php
LINE: 66
CALL: module->load()

كود: تحديد الكل

SQL ERROR [ mysql4 ]

Unknown column 't.template_inherit_path' in 'field list' [1054]

SQL

SELECT s.style_id, t.template_storedb, t.template_path, t.template_id, t.bbcode_bitfield, t.template_inherits_id, t.template_inherit_path, c.theme_path, c.theme_name, c.theme_storedb, c.theme_id, i.imageset_path, i.imageset_id, i.imageset_name FROM phpbb_styles s, phpbb_styles_template t, phpbb_styles_theme c, phpbb_styles_imageset i WHERE s.style_id = 18 AND t.template_id = s.template_id AND c.theme_id = s.theme_id AND i.imageset_id = s.imageset_id

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()

FILE: includes/session.php
LINE: 1558
CALL: dbal_mysql->sql_query()

FILE: adm/index.php
LINE: 27
CALL: user->setup()

كود: تحديد الكل

-- phpMyAdmin SQL Dump
-- version 2.11.9.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 24, 2009 at 09:12 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.6

--
-- Database: `motamiz_soft`
--

-- --------------------------------------------------------

--
-- Table structure for table `phpbb_styles_template`
--

CREATE TABLE IF NOT EXISTS `phpbb_styles_template` (
  `template_id` mediumint(8) unsigned NOT NULL auto_increment,
  `template_name` varchar(255) collate utf8_bin NOT NULL default '',
  `template_copyright` varchar(255) collate utf8_bin NOT NULL default '',
  `template_path` varchar(100) collate utf8_bin NOT NULL default '',
  `bbcode_bitfield` varchar(255) collate utf8_bin NOT NULL default 'kNg=',
  `template_storedb` tinyint(1) unsigned NOT NULL default '0',
  `template_inherits_id` int(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (`template_id`),
  UNIQUE KEY `tmplte_nm` (`template_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=16 ;

--
-- Dumping data for table `phpbb_styles_template`
--

INSERT INTO `phpbb_styles_template` (`template_id`, `template_name`, `template_copyright`, `template_path`, `bbcode_bitfield`, `template_storedb`, `template_inherits_id`) VALUES
(15, 'prosilver', '© phpBB Group, 2007', 'prosilver', 'lNg=', 1, 0),
(14, 'subsilver2', '© phpBB Group, 2003', 'motamiz-brown', 'kNg=', 0, 0);