mysql_updater problem ?

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
bloodmage
Registered User
Posts: 52
Joined: Sun May 17, 2009 9:04 pm

mysql_updater problem ?

Post by bloodmage »

hello world ,

when i go to mysite.com/mysql_upgrade.php i have this .

Image ( and more )

https://camo.phpbb.com/0c62e31f4825ac83c56cc861c5212c7e13a2b564/687474703a2f2f696d67352e696d616765736861636b2e75732f696d67352f393539342f7465737470786d2e6a7067

i dont know if i go to this site i will have a this as the picture visual .

when i am on this link what i need to doe ? ( its all time same : modify , modify , ... ... )

thanks in advance bloodmage .

User avatar
Erik Frèrejean
Former Team Member
Posts: 9899
Joined: Tue Oct 09, 2007 9:09 am
Location: The Netherlands, 3.0.x Support Forum
Name: Erik Frèrejean
Contact:

Re: mysql_updater problem ?

Post by Erik Frèrejean »

You need to copy the output and run it on the database directly though a tool like phpMyAdmin. This is also explained in the KB article.
Knowledge Base - Doesn't have a default value errors
Support Toolkit | Support Request Template | Knowledge Base | phpBB 3.0.x documentation
I don't give support via PM or IM! (all unsolicited pms will be trashed!)

bloodmage
Registered User
Posts: 52
Joined: Sun May 17, 2009 9:04 pm

Re: mysql_updater problem ?

Post by bloodmage »

hello , so i have doe what you have say ,

so i have go to mysite.com/mysql_upgrader.php then i have copy the all page code ,

then i have to to mysite.com/phpmyadmin here i have click on sql then i have paster all page code .

and i have this :

Code: Select all

Erreur

requête SQL:

USE 1026484 -1;

MySQL a répondu:Documentation
#1064 - 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 '1026484-1' at line 1 
and in the picture i havent see the all page code but only one this as that :

http://www.ktuk.net/kb/4.jpg

do i have copy the right thing ?

thanks in advance bloodmage .

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 26030
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: mysql_updater problem ?

Post by Paul »

Remove this line from the output and run it again;

Code: Select all

USE 1026484 -1;
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51191
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: mysql_updater problem ?

Post by stevemaury »

Could you please pastebin the output rather than posting an image of it?

http://www.phpbb.com/pastebin/add.php
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)

bloodmage
Registered User
Posts: 52
Joined: Sun May 17, 2009 9:04 pm

Re: mysql_updater problem ?

Post by bloodmage »

damn ,

the sql have be correctly modified but when i make forum i have again this problem :

Code: Select all

General Error
SQL ERROR [ mysqli ]

Field 'forum_seo_key' doesn't have a default value [1364]

SQL

INSERT INTO phpbb_forums (parent_id, forum_type, forum_status, forum_parents, forum_name, forum_link, forum_desc, forum_desc_uid, forum_desc_options, forum_desc_bitfield, forum_rules, forum_rules_uid, forum_rules_options, forum_rules_bitfield, forum_rules_link, forum_image, forum_style, display_subforum_list, display_on_index, forum_topics_per_page, enable_indexing, enable_icons, enable_prune, prune_days, prune_viewed, prune_freq, forum_password, forum_name_colour, forum_flags, left_id, right_id) VALUES (1, 1, 0, '', 'test', '', 'test', '', 7, '', '', '', 7, '', '', '', 0, 1, 1, 0, 1, 1, 1, 7, 7, 1, '$H$9cveJjFzdR6ltBjOU0fZMjgWhIoj3v.', 'FF0000', 48, '12', 13)

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/acp/acp_forums.php
LINE: 1049
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/acp_forums.php
LINE: 183
CALL: acp_forums->update_forum_data()

FILE: includes/functions_module.php
LINE: 507
CALL: acp_forums->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()
one member have ask to me if i doe that this will remove the bug ...

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 26030
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: mysql_updater problem ?

Post by Paul »

That error is caused by your seo MOD. You will need to ask for support for that at the topic for the MOD.
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

bloodmage
Registered User
Posts: 52
Joined: Sun May 17, 2009 9:04 pm

Re: mysql_updater problem ?

Post by bloodmage »

Paul wrote:That error is caused by your seo MOD. You will need to ask for support for that at the topic for the MOD.
i have doe that and some one asked me i need upgrade mysql ...

and i know when i unstall it i need delete to my phpmyadmin but the 3 table its not here ...

i will post in the mod again .

stokerpiller
Registered User
Posts: 1934
Joined: Wed Feb 28, 2007 8:06 pm

Re: mysql_updater problem ?

Post by stokerpiller »

The mentoined mod is recently validated by the mod team.

The doesn't have a default value thing is a database schema problem.
Its there with or without the mod.

Solution would be to uninstall the mod and run the upgrader and then reinstall mod?
I am done with phpBB

User avatar
JimA
Community Team Leader
Community Team Leader
Posts: 7725
Joined: Thu Jul 31, 2008 5:54 am
Location: The Netherlands
Name: Jim Mossing Holsteyn
Contact:

Re: mysql_updater problem ?

Post by JimA »

stokerpiller wrote:The doesn't have a default value thing is a database schema problem.
Its there with or without the mod.
That's not true.

This particular case has to do with the MOD, because this user has already used the MySQL updater for all standard phpBB fields. The field MySQL is complaining about now is a field added by the MOD, which is of course not update by the mysql_updater.php file, because it doesn't know the field at all. Therefore, you need to go to the MOD Author with this error, we can't help you with it.
Image Jim Mossing Holsteyn - Community Team Leader
Knowledge Base | Documentation | Board rules

If you're having any questions about the rules/customs of this website, feel free to drop me a PM.

stokerpiller
Registered User
Posts: 1934
Joined: Wed Feb 28, 2007 8:06 pm

Re: mysql_updater problem ?

Post by stokerpiller »

Well, I am the author ;)

Step 1, uninstall the mod
Step 2, run the upgrader
Step 3, install the mod again

The database schema is now updated and should add the correct entries when running the SQL, which in this case is:

Code: Select all

ALTER TABLE phpbb_forums ADD forum_seo_key varchar(255) NOT NULL;
ALTER TABLE phpbb_forums ADD forum_seo_desc TEXT NOT NULL;
ALTER TABLE phpbb_forums ADD forum_seo_bottom TEXT NOT NULL;
I am done with phpBB

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 26030
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: mysql_updater problem ?

Post by Paul »

And still, this is not a problem with the database updater, as this only update core tables. It stays a problem with the MOD.
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

stokerpiller
Registered User
Posts: 1934
Joined: Wed Feb 28, 2007 8:06 pm

Re: mysql_updater problem ?

Post by stokerpiller »

I never said it was a problem with the database updater.
But I said, and still say, it is a well known problem with the database schema.

If your database schema is correct, you will have no problem with the Forum SEO mod.

I am not 100% sure of the following, databases is not my thing.
If the database updater was run before installing the mod, there wouldnt have been any problems.
Therefore removing the entries made by this mod, doing the database updater and reinstalling the mod would have been the solution.
I am done with phpBB

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 26030
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: mysql_updater problem ?

Post by Paul »

Then your installer is incorrect, as your installed should run a query based of the mysql version. The default error comes due to a mysql upgrade or config change. The orginal created scheme was correct for that version,b tu after this change its not working anymore, thats the problem.
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

Locked

Return to “[3.0.x] Support Forum”