Replace VALUE+1 with the number one greater than the number you get when you select maximum value for the auto_increment column.

-Craig

On Thu, Dec 25, 2008 at 10:41 AM, Steve Kessler skessler@denverdataman.com wrote:

The problem is the max numbers but this command

alter table accesslog auto_increment=VALUE+1;

does not work " #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 'VALUE+1' at line 1". Where should I be putting aid (the field name) to make this SQL statement execute.

Thanks, Steve

Steve Kessler Denver DataMan 303-587-4428 Sign up for the Denver DataMan Free eNewsletter

-----Original Message----- From: Craig Forbes [mailto:cpforbes@gmail.com] Sent: Tuesday, December 23, 2008 1:56 AM To: support@drupal.org Subject: Re: [support] Database problem

I can't be sure but from your limited description, I'm guessing that somehow you have gotten your auto increment values out of sync with the maximum value in that table.

I'm not sure what column is the auto_increment column in that table but if that is the problem here is the solution:

NOTE: Before attempting this solution backup your database if you haven't already. In fact, even if you already have backed it up back it up again before attempting this.

1. figure out what the max value for the auto_increment columns is:

select max(COLNAME) from accesslog;

note the result.

2. To check if this is the problem you can use this command:

show table status like 'accesslog'

if the auto_increment column is less than the max value noted in step 1 then this is your problem.

3. to reset the auto_increment value:

alter table accesslog auto_increment=VALUE+1;

...

From your other problem it seems possible that you have a corrupted

database. Are you able to do a mysqldump on the database? If not try to dump each table individually.

-Craig

On Mon, Dec 22, 2008 at 5:55 PM, Steve Kessler skessler@denverdataman.com wrote:

...

I am sorry to resubmit this but I have not head back and the problem is

now

...

getting worse.

I am now getting this message if not logged in:

user warning: Duplicate entry '237595' for key 1 query: INSERT INTO accesslog (title, path, url, hostname, uid, sid, timer, timestamp) values('Affiliate Partner Programs ', 'node/198', '', '24.9.62.24', 1, '25c7d7324789e378b9c4fc9c2e66922e', 799, 1229989930) in /home/kadimaso/public_html/denverdataman/includes/database.mysql.inc on

line

...

I have tried to repair the tables in PHP My Admin and any help is much appreciated.

-- [ Drupal support list | http://lists.drupal.org/ ]

-- [ Drupal support list | http://lists.drupal.org/ ]

Hi Robin,

There are lots of different ways to do what you want. From Drupal's perspective there is no difference between a photo and an image for graphics purposes. Some of the things that will determine what route you take:

1. Do you need *inline* insertion of images? You've got a lot more choices, especially if editors are not technical people, if you do* not *need inline insertion. Probably imagefield, filefield, or asset modules in combination with imagecache would provide the most flexible results and would be quite easy for the end user. Placement of the images is done via theming and provides a really consistent look that editors can't break.

2. If you do need inline insertion -- you've got the image/img_assist combination. The problem with image module in general is that it creates a node for each image. Nodes come with a lot of overhead and most people say, if an image isn't going to benefit from being a node, then don't use image module. If you are using TinyMCE on your site then asset module in combination with TinyMCE could be a great solution. A popular lightweight solution for folks needing inline images is the IMCE module, and it's really robust in Drupal 6. As you suggested, you can simply upload your images to your server (or any server actually, doesn't need to be hosting your Drupal site) and use img tags. Just make sure its in your files directory if you have them local. You can create a new folder for easier organization though using the same directory as another image module would probably be okay. But even if you are going to put the image tag directly in the content, I'd recommend the image tag in combination with Drupal core's upload module. After you've uploaded the image, the upload module provides you with the url which you can put in the img tag. That way the node itself would have a reference to the image or images you are using in that node. Make sure your imput format is set to accept the img tag.

Lots of choices... ultimately you'll choose a way -- which, based on your learning... may not be what you choose next time. That's Drupal for you!

Let us know what you do,

Shai

On Tue, Dec 23, 2008 at 7:30 AM, Clarke Robin < Robin.Clarke@networkrail.co.uk> wrote:

Hi all,

I have a question around the best way to handle images refereed to by the HTML for the body of a page type node. To be more specific, I am not talking about general photographs, for which I would use the Image module to handle resizing and galleries, but graphic type images.

These images are generally used for diagrams or graphs in newspaper articles to break up all the text. A good example is the graph at the top of the article on this page - http://news.bbc.co.uk/1/hi/business/7764741.stm

How should I add these kinds of images to Drupal? Should I even add them to Drupal (e.g. using Upload or Image, etc)?

Or should I just FTP the files to my web server, and then refer to them in the <img> tag directly? e.g. <img src="/some_directory/my_image.gif">

If FTP-ing the files, which is the best folder to store the file in? (Would storing these files in the 'images' folder cause confusion with the Image module, and some with the 'files' and Upload module?)

Is there a 'best practise' for this?

Many thanks

robin

---

The content of this email (and any attachment) is confidential. It may also be legally privileged or otherwise protected from disclosure.

This email should not be used by anyone who is not an original intended recipient, nor may it be copied or disclosed to anyone who is not an original intended recipient.

If you have received this email by mistake please notify us by emailing the sender, and then delete the email and any copies from your system.

Liability cannot be accepted for statements made which are clearly the senders own and not made on behalf of Network Rail.

Network Rail Infrastructure Limited registered in England and Wales No. 2904587, registered office Kings Place, 90 York Way London N1 9AG

---

-- [ Drupal support list | http://lists.drupal.org/ ]