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