مشكلة بقاعدة البيانات

[Masrawy]

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

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

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.

????????


??? ??? ??? ??????? ??? ??? ?????? ?? ??? ?????? ????? ???????? ? ???? ???? ?? ???? ????? ?????? ??????? ????? ?????? ???????. ????? ?? ????? ???? ? ???? ? ???????? ?????????? dbuser ??? ?? ???? ?????? ?? ?????????? ???? ????? ??? ????? ????? ????????. ??? ????? / database_update.php ???? ???? ?? ???? ????? ????? ???????? ????? ?? ????? ?? ????? ??? ???????

[saanina]

Masrawy
???? ??? ??? ???? ????????? ???? ????? ?? ?

??? ??? ????? ????????? ??? ???? database_update.php ??? ??? ??? ?, ????? ??? ?

[Masrawy]

??? ????????? ???? ??? ?????? ?????
? ??? ????
database_update.php

????

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

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

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


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

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


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

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


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

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

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

?? ?????
?????
phpbb3.0.2

[saanina]

??? template_inherit_path ?? ???? ??? ?? ????? ??? 3.0.2 !

???? ?? ???? ?????? phpbb_styles_template ??? ??? ??????

[Masrawy]

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

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()

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

[Masrawy]

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

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()

[saanina]

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

[Masrawy]

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

???? ?? ???? ?????? phpbb_styles_template ??? ??? ??????

????

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

-- 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);

[Masrawy]

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

[Masrawy]

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

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

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

[Masrawy]

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