general error on phpbb seo premod 3.02

phpBB SEO Premod for phpBB3 support forum.
This premodded version of phpBB3 includes the three different type of URL rewriting for phpBB3 by phpBB SEO. It comes with several other Search Engine Optimization mods installed.

Moderator: Moderators

general error on phpbb seo premod 3.02

Postby apashi » Wed Feb 18, 2009 10:58 am

"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!
apashi
 
Posts: 14
Joined: Fri Jul 25, 2008 3:57 pm

Advertisement

Re: general error on phpbb seo premod 3.02

Postby dcz » Tue Feb 24, 2009 3:33 pm

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 ?
Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21376
Joined: Fri Apr 28, 2006 9:03 pm

Re: general error on phpbb seo premod 3.02

Postby apashi » Wed Feb 25, 2009 5:38 pm

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!
apashi
 
Posts: 14
Joined: Fri Jul 25, 2008 3:57 pm

Re: general error on phpbb seo premod 3.02

Postby SeO » Wed Feb 25, 2009 5:55 pm

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).
SeO
Admin
Admin
 
Posts: 6334
Joined: Wed Mar 15, 2006 9:41 pm

Re: general error on phpbb seo premod 3.02

Postby apashi » Wed Feb 25, 2009 6:10 pm

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!
apashi
 
Posts: 14
Joined: Fri Jul 25, 2008 3:57 pm

Re: general error on phpbb seo premod 3.02

Postby SeO » Wed Feb 25, 2009 11:01 pm

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.
SeO
Admin
Admin
 
Posts: 6334
Joined: Wed Mar 15, 2006 9:41 pm

Re: general error on phpbb seo premod 3.02

Postby apashi » Thu Feb 26, 2009 7:29 am

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;
.......................
.......................
apashi
 
Posts: 14
Joined: Fri Jul 25, 2008 3:57 pm

Re: general error on phpbb seo premod 3.02

Postby dcz » Thu Feb 26, 2009 8:24 pm

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.

++
Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21376
Joined: Fri Apr 28, 2006 9:03 pm

Re: general error on phpbb seo premod 3.02

Postby apashi » Mon Mar 02, 2009 10:22 pm

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!
apashi
 
Posts: 14
Joined: Fri Jul 25, 2008 3:57 pm

Re: general error on phpbb seo premod 3.02

Postby dcz » Fri Mar 06, 2009 10:06 pm

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

++
Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21376
Joined: Fri Apr 28, 2006 9:03 pm


Return to phpBB SEO Premod

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 21 guests