|
Page 1 of 1
|
 Lucky 
Joined: August 2006
Posts: 106
|
 SQL Error 1064 Aphrodite Template Doesn't Work
Hi I have the IcyPhoenix 1.1.0.15b installed and I can see that after this installation I have not the Aphorodite template that I had before with 1.1.0.15a but the same that I can see in this forum. So I went inside the ACP to set aphorodite as default template but I have just aphrodite as default templates ... very strange because it isn't true ! So I try to click on OK button to confirm the page setting without changing nothing ... and appear this error message :
CBACK CrackerTracker non può eseguire correttamente le operazioni sul database.
DEBUG MODE
SQL Error : 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 'text/javascript"> ")
Line : 637
File : class_ct_adminfunctions.php
I have tried to set the Debug mode to "true" but nothing is changed
What can I do to return with my Aphrodite template ? What is the problem ?
|
#1 Sat 08 Sep, 2007 14:48 |
|
Sponsors
|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
| |
Lucky
Joined: August 2006
Posts: 106
|
Re: SQL Error 1064 Aphrodite Template Doesn't Work
I have Mysql 5
|
#2 Sat 08 Sep, 2007 14:56 |
|
Lucky
Joined: August 2006
Posts: 106
|
Re: SQL Error 1064 Aphrodite Template Doesn't Work
Thi is part of code of class_ct_adminfunctions.php with row number :
627 while ( $row = $db->sql_fetchrow($result) )
628 {
629 if( !get_magic_quotes_gpc() )
630 {
631 $row['config_name'] = addslashes($row['config_name']);
632 $row['config_value'] = addslashes($row['config_value']);
633 }
634 $sql2 = 'INSERT INTO ' . CTRACKER_BACKUP . ' (`config_name`, `config_value`) VALUES ("'. $row['config_name'] . '", "'. $row['config_value'] . '")';
635 if ( !$result2 = $db->sql_query($sql2) )
636 {
637 message_die(GENERAL_ERROR, $lang['ctracker_error_database_op'], '', __LINE__, __FILE__, $sql2);
638 }
639 }
What could be the problem for you ?
Please help me ...
|
#3 Sun 09 Sep, 2007 00:46 |
|
Lucky
Joined: August 2006
Posts: 106
|
Re: SQL Error 1064 Aphrodite Template Doesn't Work
Thsnks to italian support now I can chose aphrodite template without having CT error, Is necessary to change Automatic Restore in CT impostation to OFF.
But now I have ONLY aphrodite and if I want to change in future to MG THEME ICE or GREY I can't !!!
Why ? I can choose only Aphrodite for default template, but not MG Themes and I can't choose aphrodite color (blu, yellow, etc.)
My website has some kind of problem ?
|
#4 Mon 10 Sep, 2007 19:13 |
|
Mighty Gorgon
Luca Libralato
Joined: August 2006
Posts: 7192
Location:  Borgo San Michele
|
Re: SQL Error 1064 Aphrodite Template Doesn't Work
I guess you have a corrupted themes installation.
I would empty your themes tables and reinstall themes from scratch.
## `phpbb_themes`
##
INSERT INTO `phpbb_themes` (`themes_id`, `template_name`, `style_name`, `head_stylesheet`, `body_background`, `body_bgcolor`, `body_text`, `body_link`, `body_vlink`, `body_alink`, `body_hlink`, `tr_color1`, `tr_color2`, `tr_color3`, `tr_class1`, `tr_class2`, `tr_class3`, `th_color1`, `th_color2`, `th_color3`, `th_class1`, `th_class2`, `th_class3`, `td_color1`, `td_color2`, `td_color3`, `td_class1`, `td_class2`, `td_class3`, `fontface1`, `fontface2`, `fontface3`, `fontsize1`, `fontsize2`, `fontsize3`, `fontcolor1`, `fontcolor2`, `fontcolor3`, `span_class1`, `span_class2`, `span_class3`, `img_size_poll`, `img_size_privmsg`, `online_color`, `offline_color`, `hidden_color`) VALUES (1, 'mg_themes', 'Icy Phoenix', 'style_ice.css', 'ice', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'row1', 'row2', '', '', '', '', 10, 11, 12, '', '22BB33', 'DD2222', '', '', '', 0, 0, '008000', 'DD0000', 'EECC00');
## `phpbb_themes_name`
##
INSERT INTO `phpbb_themes_name` (`themes_id`, `tr_color1_name`, `tr_color2_name`, `tr_color3_name`, `tr_class1_name`, `tr_class2_name`, `tr_class3_name`, `th_color1_name`, `th_color2_name`, `th_color3_name`, `th_class1_name`, `th_class2_name`, `th_class3_name`, `td_color1_name`, `td_color2_name`, `td_color3_name`, `td_class1_name`, `td_class2_name`, `td_class3_name`, `fontface1_name`, `fontface2_name`, `fontface3_name`, `fontsize1_name`, `fontsize2_name`, `fontsize3_name`, `fontcolor1_name`, `fontcolor2_name`, `fontcolor3_name`, `span_class1_name`, `span_class2_name`, `span_class3_name`) VALUES (1, 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '');
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#5 Mon 17 Sep, 2007 01:17 |
|
|
|
Page 1 of 1
|
 Was this topic useful?
 Was this topic useful?
| Link this topic |
|---|
| URL |
|
| BBCode |
|
| HTML |
|
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
|
|
|
|
