UDPATE table1 SET id = 0; How to fix it: Be sure to check your commands prior to running them and ensure they are all spelled correctly. Kind regards, Nick Follow us on Twitter - twitter.com/OSTraining Like us on Facebook - facebook.com/ostraining Please become a member of OSTraining to reply to this post. If you try to do another export, do you get the same information within the .sql file? Login 0 items Join Now Login Join Now Search Home Joomla! http://thatcom.net/xml-error/xml-error-syntax-error-at-line-1-joomla-update.html
Thank You for the answer it will be highly appreciated. Before I start, I did notice that the copy of my site contains Admintools--the component, module and plugin. Can you confirm that you pasted in the full query? Its like as soon as I have imported the most recent database to MAMP, it had an affect on the live server, which I didn't even think was possible?
Also you may want to change the column type to timestamp instead of varchar if you have that currently set. The ORDER BY itself does not need the WHERE clause, so if you do not need anything else in the WHERE, simply removing it may correct the issue. Please become a member of OSTraining to reply to this post. upgrade from 1.6.0 to 1.7 4 years 9 months ago #36108 woodie NOW ONLINE Posts: 196 okay, reinstalled admintools, but got this error message on the install page: JFolder: :files: Path
Troubleshooting is a process of elimination. upgrade from 1.6.0 to 1.7 4 years 9 months ago #36138 woodie NOW ONLINE Posts: 196 Okay, that's done. Second question. I´m trying to find
and replace with
in a wp_posts table.
Tweet News / Announcements Support Center Login Username Password Remember Me Log in Create an account Forgot your username? Thank you, John-Paul Reply Ali Zaghir n/a Points 2014-05-21 4:39 pm Hi, please help me solve this error!. If yes the minimum required version by Joomla is 5.3 » Technical requirements - Joomla! Thanks David Forum Guide Please search forums before posting.
When I deleted it from my directory everything worked normally. It just says unpack the archive file. Please become a member of OSTraining to reply to this post. Thanks Reply JeffMa Staff 11,186 Points 2014-04-14 12:37 pm Importing your live site's database into your development environment should not affect your live site at all, unless you have
Should I attach a different database - a default Joomla installation one perhaps & see if that works? First time with PHP/MySql so was nearing frustration. to 16.00 p.m. So, if your .html file contains "" or "?>" tags/text (which shows for file parser that PHP code started), you get this error.
I'm not sure where you're getting this code, but it doesn't look like it's from a MySQL export. http://thatcom.net/xml-error/xml-error-syntax-error-at-line-1-rockettheme.html Then, all of the sudden, without installing anything else, I tried to modify the template trough Joomla Template Manager, and got this error message (XML error: syntax error at line 1) Which movie series are referenced in XKCD comic 1568? Hopefully, we'll see more information soon.
To use it as the column name you need to enclose it in backticks ``. Joomla Version 1.5.15 URL: http://magni.webcity.com.au/~bes47125/water-alerts/ Any help with solving this error or even removing the display of it would be greatly appreciated. CREATE TABLE ibf_admin_logs ( id bigint(20) NOT NULL auto_increment, act varchar(255) default NULL, code varchar(255) default NULL, member_id int(10) default NULL, ctime int(10) default NULL, note text NULL, ip_address varchar(255) default http://thatcom.net/xml-error/xml-error-syntax-error-at-line-1-joomla-template.html Then what?
I contacted my provider and he told me that libxml was installed, and that litespeed is supposed to be drop-in compatible with Apache. I'll have to come back to this later. I did go directly to the Concrete5 Forums and that very same error is reported there.
current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. I found this exact code at the very bottom of the database .sql file, after I had exported it from phpMyAdmin. Here's a tutorial: www.ostraining.com/blog/joomla/how-to-up...min-tools-extension/ It will upgrade your site to Joomla 1.6.5/6 then to 1.7.3. Please verify if it is correct (replace it with one from quickstart or Joomla package, jsut verify you are using same version).
It's a bit difficult to troubleshoot an SQL error without actually seeing the entire query that you're running. You will need to be registered in order to make any comments on their forum. Upgrade Notification, System - Admin Tools and Admintools. http://thatcom.net/xml-error/xml-error-syntax-error-at-line-1-joomla-1-7.html Contact Support: Support Chat SKYPE 888.321.HOST(4678) WEB HOSTING BUSINESS HOSTING VPS HOSTING DEDICATED SERVERS RESELLER HOSTING WORDPRESS HOSTING MANAGED HOSTING PREMIER SUPPORT ™ DOMAINS WEB DESIGN WEB DESIGN SERVICES CREATE YOUR
Here's path to temp folder: /Applications/MAMP/htdocs/vwca/tmp Change what to temp? The error that im getting is: UPDATE .`wp_posts` SET `post_content` = REPLACE(`post_content`, '
On their guide it does mention "For the video tutorial, we are connected to phpMyAdmin using the "root" MySQL user. As you can see, there are a number of different ways to make this update. can you help me please... Reply scott Staff 40,236 Points 2014-05-10 8:30 am Hello Joe, Thank you for your question.
Let us know if you have any further questions or comments. upgrade from 1.6.0 to 1.7 4 years 9 months ago #35909 woodie NOW ONLINE Posts: 196 I'm doing this on my local backup, my live site is untouched so far.