Under Consideration: Migrate the Forums to Discourse Post: 303045020

Sponsored Content

The Lounge What is on Your Mind? Under Consideration: Migrate the Forums to Discourse Post 303045020 by Neo on Wednesday 11th of March 2020 01:03:26 AM

03-11-2020

Administrator

Commenting out, as I suspected did not fix the error, and as expected, commenting out the JOIN just exposed other issues:

Code:

Unknown column 'a.filedataid' in 'field list'
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
            WHERE a.attachmentid = 3135
  1013769 / 651396 (155.6%)  SQL Error
Unknown column 'a.filedataid' in 'field list'
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
            WHERE a.attachmentid = 7575
SQL Error
Unknown column 'a.filedataid' in 'field list'
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
            WHERE a.attachmentid = 7576
SQL Error
Unknown column 'a.filedataid' in 'field list'
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
            WHERE a.attachmentid = 7577
SQL Error
Unknown column 'a.filedataid' in 'field list'
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
            WHERE a.attachmentid = 7578
SQL Error
Unknown column 'a.filedataid' in 'field list'
SELECT a.attachmentid attachment_id, a.userid user_id, a.filedataid file_id, a.filename filename,
                  LENGTH(fd.filedata) AS dbsize, filedata, a.caption caption
             FROM attachment a
            WHERE a.attachmentid = 7584
  1059653 / 651396 (162.7%)

However, this only effects around 8 attachments (over the lifetime of the forums), so I think we can live with 6 "skips" for sure.

Smilie

Neo

View Public Profile for Neo

Visit Neo's homepage!

Find all posts by Neo

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to migrate ?

Currently, I am planning a migration between machine which under True64UNIX. The new machine will run with higher version O/S. My question is, is there any solution on migrating one machine to another which with different O/S version? My goal is keeping minimum impact to the users. Excuse my...

2. UNIX for Dummies Questions & Answers

Pipe not taken into consideration

I'm trying to see every file which my group (staff) has in a certain directory, recursively. The pipe ls -l -R | grep staff is not working exactly as I want, as for every directory to which my user does not have access, a line like: ls: ./directory/lost+found: The file access permissions do not...

3. Solaris

Migrate oracle solaris 5.8 5.9

If I have an oracle 9 database environment on a san running solaris 5.8 as the os. Can I plug the san into a Solaris 5.9 environment and have the database work ? - as long as binaries are on the san

4. Solaris

Can you migrate UFS to ZFS ?

I have some UFS volumes (non root), that I would like to change into ZFS volumes. Is this possible ? I think the only method is to create a new zfs volume and copy the data accoss, this would take a long time for us. Is there a quicker way ? Regards

5. Solaris

Migrate from MPXIO to Powerpath

Here is the issue: I am building a database server using Solaris 10x86 U8. The system is jumpstarted with mpxio enabled and booting from the san. We need to have powerpath 5.3 installed and would like to have powerpath take control of the the boot san as well or have mpxio control the san...

6. Linux

Mysql Migrate

Hi , I would like to (MYSQL) migrate the all the data from solari's to linux box. I have checked whether mysql is installed or not. rpm -qa | grep -i mysql I confirmed !!!! I want to know the following points. 1) How can get to know what are mysql data files and location as well....

7. BSD

Migrate a Hard Disk

hi Has anyone already tried to migrate a hard disk with FreeBSD using recoverdisk?

8. Shell Programming and Scripting

Migrate from FTP to SFTP

Hi,I am using following code for FTP in shell script file and it is working.Now I want to migrate from FTP to SFTP.What code changes/steps I have to perform for SFTP ? ftp -in <<FIN open $SAP_UP_SERVER user $SAP_UP_USER $SAP_UP_PASSWORD asc put...

LEARN ABOUT DEBIAN

kdevelop

KDEVELOP(1)						      General Commands Manual						       KDEVELOP(1)

NAME

       kdevelop - Integrated Development Environment for KDE

SYNOPSIS

       kdevelop [Qt-options] [KDE-options] [options] file(s)

DESCRIPTION

       KDevelop is an integrated development environment for KDE.

PROGRAM OPTIONS

       --profile <profile>
	      Profile to load.

       --project <project>
	      Project to load.

       file(s)
	      Files to load.

GENERIC OPTIONS

       --help Show help about options.

       --help-qt
	      Show Qt specific options.

       --help-kde
	      Show KDE specific options.

       --help-all
	      Show all options.

       --author
	      Show author information.

       -v, --version
	      Show version information.

       --license
	      Show license information.

       --     End of options.

QT OPTIONS

       --display <displayname>
	      Use the X-server display `displayname'.

       --session <sessionId>
	      Restore the application for the given `sessionId'.

       --cmap Causes the application to install a private color map on an 8-bit display.

       --ncols <count>
	      Limits the number of colors allocated in the color cube on an 8-bit display, if the application is using the QApplication::ManyColor
	      color specification.

       --nograb
	      Tells Qt to never grab the mouse or the keyboard.

       --dograb
	      Running under a debugger can cause an implicit -nograb, use -dograb to override.

       --sync Switches to synchronous mode for debugging.

       --fn, --font <fontname>
	      Defines the application font.

       --bg, --background <color>
	      Sets the default background color and an application palette (light and dark shades are calculated).

       --fg, --foreground <color>
	      Sets the default foreground color.

       --btn, --button <color>
	      Sets the default button color.

       --name <name>
	      Sets the application name.

       --title <title>
	      Sets the application title (caption).

       --visual TrueColor
	      Forces the application to use a TrueColor visual on an 8-bit display.

       --inputstyle <inputstyle>
	      Sets XIM (X Input Method) input style. Possible values are onthespot, overthespot, offthespot and root.

       --im <XIM server>
	      Set XIM server.

       --noxim
	      Disable XIM.

       --reverse
	      Mirrors the whole layout of widgets.

KDE OPTIONS

       --caption <caption>
	      Use `caption' as name in the titlebar.

       --icon <icon>
	      Use `icon' as the application icon.

       --config <filename>
	      Use alternative configuration file.

       --nocrashhandler
	      Disable crash handler, to get core dumps.

       --waitforwm
	      Waits for a WM_NET compatible windowmanager.

       --style <style>
	      Sets the application GUI style.

       --geometry <geometry>
	      Sets the client geometry of the main widget.

SEE ALSO

       More detailed user documentation is available from help:/kdevelop (either enter this URL into konqueror,  or  run  `khelpcenter	help:/kde-
       velop').

																       KDEVELOP(1)