Joomla.it Forum
Non solo Joomla... => Sezione dedicata ai Server => : romoletto64 21 Sep 2007, 12:39:28
-
HO JOOMLA ULTIMA VERSIONE 1.0.3 HO INSTALLATO UN TEMPLATE PER LA PARTE ADMIN MA PRIMA DI FARLO HO FATTO IL BECKUP DEL DATABASE DOPO DI QUESTO HO PROCEDUTO ALL'INSTALLAZIONE DEL TEMPLATE MA MI è SUCCESSO UN CASINO MI DAVA DELLE SCRITTE SU TUTTA LA PAGINA E HO DOVUTO ELIMINARE TUTTO IL DATA BASE E ADESSO HO UN ALTRO PROBLEMA NN RIESCO A RIPRISTINARLO MI DA QUESTO ERRORE
Errore
query SQL:
-- phpMyAdmin SQL Dump
-- version
-- http://www.phpmyadmin.net
--
-- Host: mysql4.netsons.org
-- Generato il: 20 Set, 2007 at 10:09 PM
-- Versione MySQL: 4.1.22
-- Versione PHP: 4.4.4-8+etch4
--
-- DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
-- --------------------------------------------------------
--
-- Struttura della tabella `cpg1411_albums`
--
CREATE TABLE `cpg1411_albums` (
`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 255 ) NOT NULL default '',
`description` text NOT NULL ,
`visibility` int( 11 ) NOT NULL default '0',
`uploads` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`comments` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`votes` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`pos` int( 11 ) NOT NULL default '0',
`category` int( 11 ) NOT NULL default '0',
`thumb` int( 11 ) NOT NULL default '0',
`keyword` varchar( 50 ) default NULL ,
`alb_password` varchar( 32 ) default NULL ,
`alb_password_hint` text,
PRIMARY KEY ( `aid` ) ,
KEY `alb_category` ( `category` )
) TYPE = MYISAM AUTO_INCREMENT =4 COMMENT = 'Used to store albums' AUTO_INCREMENT =4;
Messaggio di MySQL:
#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 '
CREATE TABLE `cpg1411_albums` (
`aid` int(11) NOT NULL auto_increment,
' at line 1
-
Ciao e benvenuto.
piccoli consigli
1) Scrivi in minuscolo (il maiuscolo significa che stai urlando).
2) Cambia il titolo da aiuto a "problemi importare dbsql" o qualcosa del genere, in modo che più persone leggano il tuo post.
3) non ti far prendere dal panico... vedrai che risolvi.
Ti lascio nelle mani dei più esperti di db. ;)
-
Come lo ripristini? Incollando le queries nell'apposita textarea o caricando il file del dump?
Ho provato a lanciare la query che riporti nel tuo post su un mysql 5.0 e non mi ha dato problemi.
L'errore che ti segnala è molto strano, mai capitato (mi riferisco a '), se per il ripristino hai usato il metodo del caricamento del file forse non ha trasferito il file correttamente.
Quindi riprova e in caso ancora negativo, copia il contenuto del file e incollalo nella textarea apposita (pulsante sql di phpmyadmin).
-
sembra quasi che il DB non riesca a leggere nel modo corretto i caratteri.
Con che set di caratteri e' impostato ?
-
vi ringrazio ho fatto come avete scritto e ho risolto ma il problema adesso è un altro ho installato questo mal...o template per la parte admin ho risolto il problema db ma rimane quello del template mi da scritte strane in fondo la pagina tipo:
SELECT *
FROM jos_session
WHERE session_id = 'a139af173389c150faa71cab02e4bbf9'
AND username = 'admin'
AND userid = 62--------------------------------------------------------------------------------2
SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering--------------------------------------------------------------------------------3
SELECT id, link
FROM jos_menu
WHERE menutype = 'mainmenu'
AND published = 1
ORDER BY parent, ordering
LIMIT 1--------------------------------------------------------------------------------4
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 1 )
ORDER BY menuid DESC
LIMIT 1--------------------------------------------------------------------------------5
DELETE FROM jos_session
WHERE (
( time < '1190375958' )
AND guest = 0
AND gid > 0
) OR (
( time < '1190375958' )
AND guest = 1
AND userid = 0
)--------------------------------------------------------------------------------6
SELECT id, published
FROM jos_mambots
WHERE element = 'coredesign'
AND folder = 'system'--------------------------------------------------------------------------------7
SELECT *
FROM jos_mambots
WHERE id = '32'--------------------------------------------------------------------------------8
SELECT id, published
FROM jos_modules
WHERE module = 'mod_cd_login'--------------------------------------------------------------------------------9
SELECT *
FROM jos_modules
WHERE id = '75'--------------------------------------------------------------------------------10
SELECT id, published
FROM jos_modules
WHERE module = 'mod_cd_rssfeed'--------------------------------------------------------------------------------11
SELECT id, published
FROM jos_modules
WHERE module = 'mod_cd_bookmarks'--------------------------------------------------------------------------------12
SELECT COUNT(*)
FROM jos_stats_agents
WHERE agent = 'MS Internet Explorer 6.0'
AND type = 0--------------------------------------------------------------------------------13
UPDATE jos_stats_agents
SET hits = ( hits + 1 )
WHERE agent = 'MS Internet Explorer 6.0'
AND type = 0--------------------------------------------------------------------------------14
SELECT COUNT(*)
FROM jos_stats_agents
WHERE agent = 'Windows XP'
AND type = 1--------------------------------------------------------------------------------15
UPDATE jos_stats_agents
SET hits = ( hits + 1 )
WHERE agent = 'Windows XP'
AND type = 1--------------------------------------------------------------------------------16
SELECT COUNT(*)
FROM jos_stats_agents
WHERE agent = 'net'
AND type = 2--------------------------------------------------------------------------------17
UPDATE jos_stats_agents
SET hits = ( hits + 1 )
WHERE agent = 'net'
AND type = 2--------------------------------------------------------------------------------18
SELECT *
FROM jos_menu
WHERE id = 1--------------------------------------------------------------------------------19
SELECT COUNT(a.id)
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
LEFT JOIN jos_users AS u ON u.id = a.created_by
LEFT JOIN jos_groups AS g ON a.access = g.id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2007-09-21 14:14' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-09-21 14:14' )
AND s.published = 1
AND cc.published = 1
AND a.access <= 0
AND s.access <= 0
AND cc.access <= 0--------------------------------------------------------------------------------20
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
FROM jos_content AS a
INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
INNER JOIN jos_categories AS cc ON cc.id = a.catid
INNER JOIN jos_sections AS s ON s.id = a.sectionid
LEFT JOIN jos_users AS u ON u.id = a.created_by
LEFT JOIN jos_groups AS g ON a.access = g.id
LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2007-09-21 14:14' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2007-09-21 14:14' )
AND s.published = 1
AND cc.published = 1
AND a.access <= 0
AND s.access <= 0
AND cc.access <= 0
ORDER BY f.ordering
LIMIT 4--------------------------------------------------------------------------------21
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
FROM jos_content AS a
LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
WHERE a.id = 12--------------------------------------------------------------------------------22
SELECT folder, element, published, params
FROM jos_mambots
WHERE access <= 0
AND folder = 'content'
ORDER BY ordering--------------------------------------------------------------------------------23
SELECT id
FROM jos_mambots
WHERE element = 'caldatebot'
AND folder = 'content'--------------------------------------------------------------------------------24
SELECT *
FROM jos_mambots
WHERE id = '33'--------------------------------------------------------------------------------25
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 12
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id--------------------------------------------------------------------------------26
SELECT id
FROM jos_menu
WHERE type = 'content_blog_section'
AND published = 1
AND componentid = 0--------------------------------------------------------------------------------27
SELECT id
FROM jos_menu
WHERE type = 'content_blog_category'
AND published = 1
AND componentid = 0--------------------------------------------------------------------------------28
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '12'--------------------------------------------------------------------------------29
SELECT hits FROM jos_content WHERE id = '12'--------------------------------------------------------------------------------30
SELECT count(*) FROM jos_akocomment WHERE contentid='12' AND published='1'--------------------------------------------------------------------------------31
SELECT a.*
FROM jos_components AS a
WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
AND a.option = 'com_syndicate'--------------------------------------------------------------------------------32
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id != 1
AND ( mm.menuid = 0 OR mm.menuid = 1 )
ORDER BY ordering--------------------------------------------------------------------------------33
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'mainmenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering--------------------------------------------------------------------------------34
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'othermenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering--------------------------------------------------------------------------------35
SELECT lc.id AS idcomment, lc.contentid, lc.title AS titlecomment, lc.comment AS lastcomment, lc.date AS lastpost, lc.name AS authorcomment, lc.iduser AS userId, c.id AS id, c.title AS title, c.sectionid AS id_section
FROM jos_akocomment AS lc, jos_content AS c
WHERE c.id = lc.contentid AND lc.published='1'
ORDER BY lc.id DESC
LIMIT 5--------------------------------------------------------------------------------36
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 39
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id--------------------------------------------------------------------------------37
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 36
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id--------------------------------------------------------------------------------38
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid = s.id
LEFT JOIN jos_menu AS ms ON ms.componentid = s.id
LEFT JOIN jos_categories AS c ON i.catid = c.id
LEFT JOIN jos_menu AS mc ON mc.componentid = c.id
WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
AND i.id = 30
ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id--------------------------------------------------------------------------------39
SELECT id, username, name, lastvisitDate
FROM jos_users
WHERE block='0' and lastvisitDate<>'0000-00-00 00:00:00'
ORDER BY lastvisitDate DESC LIMIT 5--------------------------------------------------------------------------------40
SELECT p.id, p.title
FROM jos_polls AS p
INNER JOIN jos_poll_menu AS pm ON pm.pollid = p.id
WHERE ( pm.menuid = 1 OR pm.menuid = 0 )
AND p.published = 1--------------------------------------------------------------------------------41
SELECT id
FROM jos_menu
WHERE type = 'components'
AND published = 1
AND link = 'index.php?option=com_poll'--------------------------------------------------------------------------------42
SELECT id, text
FROM jos_poll_data
WHERE pollid = 14
AND text != ''
ORDER BY id--------------------------------------------------------------------------------43
SELECT id, text
FROM jos_poll_data
WHERE pollid = 16
AND text != ''
ORDER BY id--------------------------------------------------------------------------------44
SELECT guest, usertype
FROM jos_session--------------------------------------------------------------------------------45
SELECT count(id) as registered FROM jos_users WHERE usertype <> 'administrator' AND usertype <> 'superadministrator'--------------------------------------------------------------------------------46
SELECT count(id) FROM jos_users WHERE to_days(registerDate) = to_days(curdate()) AND usertype <> 'administrator' AND usertype <> 'superadministrator'--------------------------------------------------------------------------------47
SELECT count(id) FROM jos_users WHERE yearweek(registerDate) = yearweek(curdate()) AND usertype <> 'administrator' AND usertype <> 'superadministrator'--------------------------------------------------------------------------------48
SELECT count(id) FROM jos_users WHERE month(registerDate) = month(curdate()) AND usertype <> 'administrator' AND usertype <> 'superadministrator'--------------------------------------------------------------------------------49
SELECT username FROM jos_users WHERE block='0' AND usertype <> 'administrator' AND usertype <> 'superadministrator' ORDER BY registerDate DESC LIMIT 1
addirittura le vedo nella home in fondo la pagina aiutatemi per favore è un sito che ho fatto per un amica e se va distrutto mi uccide :-)
-
addirittura le vedo nella home in fondo la pagina aiutatemi per favore è un sito che ho fatto per un amica e se va distrutto mi uccide :-)
E se fosse la cosa giusta da fare? :D
Hai il debug attivato. Vai in configurazione globale e disattivalo.