SOLVED Error 500 After Creating A Category Within A Forum

The time now is Thu 25 Apr, 2024 01:55 • All times are UTC + 1 Hour [DST enabled]

SOLVED Error 500 After Creating A Category Within A Forum

Page 1 of 1

batman

Karl

Joined: February 2011
Posts: 162
Location:

Cornwall UK

Error 500 After Creating A Category Within A Forum

Hya felles I'm desperate for a fix, I was creating a new subforum via ACP but selected category by accident and submitted, now I'm just getting HTTP 500 Internal Server Error.

I went in to PHPMYADMIN and deleted the new category but still getting the problem and cant access the site.
I did a backup yesterday from ACP but getting duplicate flag errors when I try to upload it to an empty DB

Code: [Download] [Hide] [Select]

Error

SQL query: 

INSERT INTO phpbb_flags (flag_id, flag_name, flag_image) VALUES (1, 'Afghanistan', 'afghanistan.png'),(2, 'AI', 'ai.png'),(3, 'Albania', 'albania.png'),(4, 'Algeria', 'algeria.png'),(5, 'AN', 'an.png'),(6, 'Andorra', 'andorra.png'),(7, 'Antiguabarbuda', 'antiguabarbuda.png'),(8, 'AO', 'ao.png'),(9, 'Argentina', 'argentina.png'),(10, 'Armenia', 'armenia.png'),(11, 'AS', 'as.png'),(12, 'Australia', 'australia.png'),(13, 'Austria', 'austria.png'),(14, 'AW', 'aw.png'),(15, 'AX', 'ax.png'),(16, 'Azerbaijan', 'azerbaijan.png'),(17, 'Bahamas', 'bahamas.png'),(18, 'Bahrain', 'bahrain.png'),(19, 'Bangladesh', 'bangladesh.png'),(20, 'Barbados', 'barbados.png'),(21, 'Belarus', 'belarus.png'),(22, 'Belgium', 'belgium.png'),(23, 'Belize', 'belize.png'),(24, 'Benin', 'benin.png'),(25, 'Bhutan', 'bhutan.png'),(26, 'BM', 'bm.png'),(27, 'Bolivia', 'bolivia.png'),(28, 'Bosnia Herzegovina', 'bosnia_herzegovina.png'),(29, 'Botswana', 'botswana.png'),(30, 'Brazil', 'brazil.png'),(31, 'Brunei', 'brunei.p[...] 

MySQL said:  

#1062 - Duplicate entry '1' for key 1

Anybody got any ideas on how to sort the error 500?

EDIT:
Sorted the flags now got this sql error, this is driving me up the wall as I need to get sorted ASAP

Code: [Download] [Hide] [Select]

Error

SQL query: 

CREATE TABLE phpbb_force_read_users(

user varchar( 255 ) DEFAULT '' NOT NULL ,

READ int( 1 ) DEFAULT '0' NOT NULL ,

time int( 10 ) DEFAULT '0' NOT NULL );

MySQL said:  

#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 'read int(1) DEFAULT '0' NOT NULL,

  time int(10) DEFAULT '0' NOT NULL

)' at line 3

EDIT 2:
Solved the error 500 by using http://yoursite/adm/erc.php and clearing cache, still need to sort the DB issue though

#1 Thu 17 Mar, 2011 19:23

Sponsors	Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.

TheSteffen

Joined: August 2006
Posts: 1625
Location:

Magdeburg

Re: Error 500 After Creating A Category Within A Forum

You can try this... if you want to insert the sql code

Code: [Download] [Hide] [Select]

CREATE TABLE `phpbb_force_read_users` (

    `user` varchar(255) NOT NULL DEFAULT '',

    `read` int(1) NOT NULL DEFAULT '0',

    `time` int(10) NOT NULL DEFAULT '0'

);

____________
TheSteffen
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support

#2 Sun 20 Mar, 2011 17:42

batman Karl Joined: February 2011 Posts: 162 Location: Cornwall UK	Re: Error 500 After Creating A Category Within A Forum TheSteffen wrote: [View Post] You can try this... if you want to insert the sql code Code: [Download] [Hide] [Select] Code: [Download] [Show] CREATE TABLE `phpbb_force_read_users` ( `user` varchar(255) NOT NULL DEFAULT '', `read` int(1) NOT NULL DEFAULT '0', `time` int(10) NOT NULL DEFAULT '0' ); Thanks Ill give that a go
#3 Sun 20 Mar, 2011 22:03

spydie

Joined: December 2008
Posts: 1796
Location:

In the Boxes

Re: Error 500 After Creating A Category Within A Forum

batman wrote: [View Post]

I went in to PHPMYADMIN and deleted the new category but still getting the problem and cant access the site.
I did a backup yesterday from ACP but getting duplicate flag errors when I try to upload it to an empty DB

If i´m not wrong, I recomended you to use MysqlDumper instead of ACP.

I had this problems once, moving a site to another server, since when, i don´t use Icy Backup utility anymore.

To many errors with doble entrys

____________
Out of Order

#4 Mon 21 Mar, 2011 14:25

Page 1 of 1

Was this topic useful?

Link this topic
URL
BBCode
HTML

The time now is Thu 25 Apr, 2024 01:55 • All times are UTC + 1 Hour [DST enabled]

Permissions List

You cannot post new topics
You cannot reply to topics
You cannot edit your posts
You cannot delete your posts
You cannot vote in polls
You cannot attach files
You can download files
You cannot post calendar events

Icy Phoenix

SOLVED Error 500 After Creating A Category Within A Forum

Was this topic useful?

Was this topic useful?