1 Reply by dreaddy

(5 replies, posted in Report Bugs here)

I was running one the earlier 2.3.xx builds.

I had the mobile module installed I think.

The backups had the missing tables and data.

I'm of the opinion that restoring would have

1.) dropped existing tables,
2) recreate the table
3) import data

It's there in the sql and that process ran fine for the existing tables.

Go to forum: Report Bugs here

2 Reply by dreaddy

(5 replies, posted in Report Bugs here)

Alrighty. I'll just talk to myself.

SOLUTION (requires a backup)

Create the table with a different table name

CREATE TABLE `FA_COMMUNITY_SUCKS_tax_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rate` double NOT NULL DEFAULT '0',
  `sales_gl_code` varchar(15) NOT NULL DEFAULT '',
  `purchasing_gl_code` varchar(15) NOT NULL DEFAULT '',
  `name` varchar(60) NOT NULL DEFAULT '',
  `inactive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)

Rename the table

RENAME TABLE `FA_COMMUNITY_SUCKS_tax_types` TO `0_tax_types`

Then insert your data

INSERT INTO `0_whatever_you_lost` VALUES (...)

As for why I have to do this song and dance. No f**king clue

Attackers dropped a couple of the tables.

Could have done much worse.

FA community appears to be dead.

This message is for those poor souls who trigger the activity counter.

Good luck with this.

Go to forum: Report Bugs here

3 Reply by dreaddy

(5 replies, posted in Report Bugs here)

Anyone???.....dang.

Does ne1 know how to restore?

or why I can't create the table?

CREATE TABLE `0_tax_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rate` double NOT NULL DEFAULT '0',
  `sales_gl_code` varchar(15) NOT NULL DEFAULT '',
  `purchasing_gl_code` varchar(15) NOT NULL DEFAULT '',
  `name` varchar(60) NOT NULL DEFAULT '',
  `inactive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)


I did a restore from an old backup...same thing.

Crap!!!!

Is frontaccounting dead?

I see some activities. So people are reading this.?

Go to forum: Report Bugs here

4 Topic by dreaddy

(5 replies, posted in Report Bugs here)

Suddenly my site doesn't have a tax table or others...not sure

DATABASE ERROR : could not get all tax types
error code : 1146
error message : Table 'frontaccounting.0_tax_types' doesn't exist
sql that failed was : SELECT * FROM 0_tax_types

Sure enough the tax table was gone.

I tried to recreate the table

CREATE TABLE `0_tax_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rate` double NOT NULL DEFAULT '0',
  `sales_gl_code` varchar(15) NOT NULL DEFAULT '',
  `purchasing_gl_code` varchar(15) NOT NULL DEFAULT '',
  `name` varchar(60) NOT NULL DEFAULT '',
  `inactive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
)

get the following error code

Error Code: 1005
Can't create table 'frontaccounting.0_tax_types' (errno: -1)

WHY?

Any ideas how to recreate the tax table? or create tables for frontaccounting?

Go to forum: Report Bugs here

5 Reply by dreaddy

(4 replies, posted in Modules Add-on's)

WP plugin Frontaccounting connect version 1.0.1 has been uploaded to github, and svn:

https://github.com/wp-plugins/frontaccounting-connect
http://plugins.svn.wordpress.org/frontaccounting-connect/

If interested. You can follow developments here

https://frontaccountingconnect.blogspot.com/
http://dreaddy.wordpress.com

Go to forum: Modules Add-on's

6 Topic by dreaddy

(4 replies, posted in Modules Add-on's)

Hi all.

Please forgive me if this is not the appropriate forum for this.

I've written a very simple Plugin for importing active Frontaccounting items into wordpress posts.

Support for widget to display imported items in sidebar and a shortcode to display items in posts or pages available. You can download and try the plugin here http://dreaddy.wordpress.com/

Hope you find this tool useful.

Go to forum: Modules Add-on's

7 Topic by dreaddy

(1 replies, posted in Setup)

Hello. The following may be a silly question but I am unable to google a decent answer.

I have the ver 2.3.9 recently installed. I added a couple of items with description.

The problem I am having is with the item search interface. Searching items work only with the item name. Does not work with the description.

I've searched the FA forums and did some googling. No-one else seems to be having this problem. I realize this could be my problem. Could use some help.


TL;DR fresh 2.3.9 install. Cannot search against the description field, only the name field. I'm an idiot. Please help.

Go to forum: Setup