"Eroare generală
SQL ERROR [ mysql4 ]

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 'AND t.template_id = s.template_id AND c.theme_id = s.theme_id AND i.imag' at line 4 [1064]

O eroare SQL a apărut în timp ce pagina era în lucru. Vă rugăm să contactaţi Administratorul forumului dacă problema persistă."

i have this error, how can i fix it?

thanks!

Hard to tell with this few information, did you just update ?

Could you activate debug in config.php and post here the full error message you have ?

SQL ERROR [ mysql4 ]

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 'AND t.template_id = s.template_id AND c.theme_id = s.theme_id AND i.imag' at line 4 [1064]

SQL

SELECT s.style_id, t.template_storedb, t.template_path, t.template_id, t.bbcode_bitfield, c.theme_path, c.theme_name, c.theme_storedb, c.theme_id, i.imageset_path, i.imageset_id, i.imageset_name FROM phpbb3_styles s, phpbb3_styles_template t, phpbb3_styles_theme c, phpbb3_styles_imageset i WHERE s.style_id = 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: 158
CALL: dbal->sql_error()

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

FILE: index.php
LINE: 26
CALL: user->setup()

i haven't make an update, i was just deleting some users, when this error ocured!

So the problem is this part :

Code: Select all

WHERE s.style_id =

No value is put in the query for this match.

Since the template table where updated in 3.0.4, I'd bet on a typo when updating index.php, double check that file to see if you find the error (winmerge can help out to do so).

http://www.phpbb.com/community/viewtopi ... 25&start=0

here is what i did ( a big mistake)

is there any solutin for me? to save my forum without reinstaling it!

thanks a lot for your support!

Install a new phpBB on a local server, do a dump of the phpBB config table and import it, then edit the server name, script path and cookie domain in it and you should have your forum back.

i exported the new phpbb config table, imported it in my forum data base, but an error ocured:

Error

SQL query:

-- -- Dumping data for table `phpbb3_config` -- INSERT INTO `phpbb3_config` (`config_name`, `config_value`, `is_dynamic`) VALUES ('active_sessions', '0', 0), ('allow_attachments', '1', 0), ('allow_autologin', '1', 0), ('allow_avatar_local', '0', 0), ('allow_avatar_remote', '0', 0), ('allow_avatar_upload', '0', 0), ('allow_bbcode', '1', 0), ('allow_birthdays', '1', 0), ('allow_bookmarks', '1', 0), ('allow_emailreuse', '0', 0), ('allow_forum_notify', '1', 0), ('allow_mass_pm', '1', 0), ('allow_name_chars', 'USERNAME_CHARS_ANY', 0), ('allow_namechange', '0', 0), ('allow_nocensors', '0', 0), ('allow_pm_attach', '0', 0), ('allow_post_flash', '1', 0), ('allow_post_links', '1', 0), ('allow_privmsg', '1', 0), ('allow_sig', '1', 0), ('allow_sig_bbcode', '1', 0), ('allow_sig_flash', '0', 0), ('allow_sig_img', '1', 0), ('allow_sig_links', '1', 0), ('allow_sig_pm', '1', 0), ('allow_sig_smilies', '1', 0), ('allow_smilies', '1', 0), ('allow_topic_notify', '1', 0)[...]

MySQL said: Documentation
#1062 - Duplicate entry 'active_sessions' for key 1


am i doing something wrong?

my export file looks like this:

-- phpMyAdmin SQL Dump
-- version 3.1.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 26, 2009 at 08:24 AM
-- Server version: 5.1.30
-- PHP Version: 5.2.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `forumxproc`
--

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

--
-- Table structure for table `phpbb3_config`
--

CREATE TABLE IF NOT EXISTS `phpbb3_config` (
`config_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`config_value` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`is_dynamic` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`config_name`),
KEY `is_dynamic` (`is_dynamic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
.......................
.......................

You need to delete all entries in the phpbb_config table before you can perform these inserts.

If not enough, make sure that there is no duplicate key indeed in your dump.

++

i deleted all the entries from config table and imported them all from an new phpbb seo premod 3.02 forum instaled, and no succes!

what should i try for next step?
www.forum.xproc.ro
thanks!

What was told in the phpBB.com thread seems correct :

ameeck wrote:If you have prosilver installed, please run this query on your database:

Code: Select all

UPDATE phpbb_config SET config_value = (SELECT style_id FROM phpbb_styles WHERE style_name = 'prosilver') WHERE config_name = 'default_style';

But make sure you backup your db before and clear phpBB's cache once done (using FTP, just delete all files in cache/ except the .htaccess).

++